WebFOCUS Online Help > ReportCaster Development and Administration > Loading User IDs Into the ReportCaster Repository > Using SQL Statements to Load ReportCaster User IDs and Groups
How to: |
When writing SQL statements to update the ReportCaster Repository with user information from an external source, you must assign valid values to the correct columns in the appropriate tables. Invalid values in the ReportCaster Repository will cause errors in ReportCaster processing. Furthermore, the structure of tables in the ReportCaster Repository may change in future releases. Therefore, SQL statements written for the current ReportCaster Repository may not be able to be migrated to new releases.
Note: A user should be a member of at least one group so that the user can be assigned to a Library Access List.
Update the BOTUPROF table with an INSERT statement as follows:
INSERT
INTO BOTUPROF (CASTER_USER, ROLE, DESCRIPTION, LIBRARY_EMAIL,ACTIVE,
CAPABILITY)
VALUES
('admin01','A','Default
Administrator','chuck_hill@ibi.com','Y','110000000000000000');
where:
Is the column for the ReportCaster user ID (for example, admin01). The value for this column may contain a maximum of 48 characters.
Is the column for the user privilege. Possible values are A for ReportCaster Administrator or N for Managed Reporting user who is not a ReportCaster Administrator.
Is the column for the user ID's description (for example, Default Administrator). The value for this column may contain a maximum of 90 characters.
Is the column for a valid e-mail address (for example, chuck_hill@ibi.com), which is required for the Report Library product. The value for this column may contain a maximum of 75 characters.
Is the column used to denote whether a user is active (Y) or inactive (N).
Is the column that consists of a series of 18 digits, where:
Is 1 if the user has scheduling capability, and 0 if user does not have scheduling capability.
Is 1 if the user has Report Library privileges, and 0 if the user does not have Report Library privileges.
Is 0 (for internal use only).
Update the BOTGUSER table with an INSERT statement as follows:
INSERT INTO BOTGUSER (CASTER_GROUP, CASTER_USER)
VALUES ('Accounting','admin01');
where:
Is the column for the ReportCaster group (for example, Accounting). The value for this column may contain a maximum of 48 characters.
Is the column for the ReportCaster user ID (for example, admin01). The value for this column may contain a maximum of 48 characters.
Update the BOTGRP table with an INSERT statement as follows:
INSERT INTO BOTGRP (CASTER_GROUP, GROUP_DESCRIPTION)
VALUES ('Accounting','Payables and Receivables');
where:
Is the column for the ReportCaster group (for example, Accounting). The value for this column may contain a maximum of 48 characters.
Is the column for the ReportCaster group description (for example, Payables and Receivables). The value for this column may contain a maximum of 90 characters.
| WebFOCUS |