Adding, Reviewing, and Modifying Data Source Security

Use the Grant Data Source Privileges (P986117) application to add, review, and modify security records for EnterpriseOne table access. EnterpriseOne stores these security records in the F986117 table.

To set up data source security records, you must first select the data source in the Data Sources (P986115) application, and then you can set up security for the data source in P986117.

Navigation to P986115: In EnterpriseOne, select the Navigator menu, EnterpriseOne Menus, EnterpriseOne Life Cycle Tools, System Administration Tools, Data Source Management, Database Data Sources.

To add a data source security record to EnterpriseOne:

Important: You must use role (or group) names that exist in the database. This application will not create the roles for you.

1. On Machine Search & Select, select the data source and then click the Select button.

2. On Work With Data Sources, click Find to load the data source records in the grid.

3. Select the row for the data source and from the Row menu, select Database Privilege.

   EnterpriseOne displays any existing privileges defined for this data source.

4. On Work With Data Source Privilege, click the Add button.

   Note: If there is an existing data source security record, you can create a new record by selecting the existing record, selecting Copy DSrc Records from the Row menu, and then modifying the copied record with a new name and privileges for the new record.

5. On Manage Data Source Privileges, in the Data Source field, enter the name of the data source or click the search button in the field to select a data source.

   After identifying the data source, the Data Source Type field displays the database type of the data source you selected.

6. Make sure that the Enable Database Security check box is selected.

7. In an empty row in the grid, add a record for the database administrator role:

   1. In the Data Source Database User / Role column, enter the exact name of the database administrator role defined in the Platform Pack Installer.

   2. In the Type column, enter or select 1 for the Database Administrator type.

   3. Press Tab to see the "Database Administrator" description and default privileges for the record.

8. In the next empty row in the grid, add a record for the database user:

   1. In the Data Source Database User / Role column, enter the exact name of the database user role defined in the Platform Pack Installer.

   2. In the Type column, enter or select 2 for the Database User type.

   3. Press Tab to see the "Database User" description and the default privileges for the record.

9. In the new records, you can adjust the default security according to your security requirements or model by selecting or clearing the check boxes in the following columns:

   • All Privileges. Selecting this check box enables all privileges.

   • Alter Table

   • Allow Index

   • Allow Select

   • Allow Insert

   • Allow Update

   • Allow Delete

10. Click the OK button to save the records.

To review or modify data source security records:

1. On Machine Search & Select (P986115), select the data source and then click the Select button.

2. On Work With Data Sources, click Find to load the data source records in the grid.

3. Select a row with the data source and from the Row menu, select Database Privilege.

4. On Work With Data Source Privilege (P986117), click Find to view the current security for the selected data source.

   In the records displayed in the grid, a check mark denotes the privileges granted to each record.

5. To modify a security record, in the appropriate row, click in any column to enable or disable the table privilege. If you enable the "All Privileges" column, then all privileges are granted.

   Remember, the privileges that you define for the role must reflect the privileges for the role in the data source.

6. Click OK to save.

   Note: As an alternative method to modify a data source security record, you can select a record and then select Manage Privilege from the Row menu.

To disable data source security:

1. On Work With Data Source Privilege, click the Add button.

2. On Manage Data Source Privileges, enter the name of the data source or click the search button to browse and select a data source.

3. Clear the Enable Database Security check box.

4. On the "Warning Disable Database Security" dialog box, click OK to turn off database security.

   Disabling the security grants all privileges to *PUBLIC in EnterpriseOne.

5. Click the OK button.

   Note: As an alternative method to disable data source security, you can access the security record in the Work With Data Source Privilege form, and then from the Row menu, select Disable Database Security.