In User Administration Setup, you can manage database users and the associated database roles, if this functionality is enabled in your environment.
This feature will be available as of V2015 R2.7. During the install process, a special step is required that is noted in the install documentation delivered with the release.
PLEASE REVIEW THE TEXT IN THIS PAGE, ESPECIALLY THE TEXT IN RED.
To enable the DB Users functionality, set Sys Item 239 (Database Users screen visibility in User Administration Center) to 1. You can also use Sys Item 201 (DEV, TEST, PROD) to allow different access based on the type of environment. Depending on the type of environment, the system will display code values of one of these three categories as allowed roles: DB_USER_DEV, DB_USER_QA, or DB_USER_PROD. ?? is this correct?
New DB Users are now assigned to predefined DB Roles which are selected according to Sys Item 201. Additionally, the EA_PROFILE profile is now applied when a new DB user is created.
If you have administrative permissions, you can use User Administration Center roles to specifically grant access to any or all of the following functionality: View DB Users, Create DB Users, Edit DB Users, Lock/Unlock DB Users, and Delete DB Users.
About the Proxy Feature
In DB Users workspace, for DEV environments only (Sys Item 201=DEV), you can also use the proxy feature (Add Write Permissions and Remove Write Permissions) to connect to the database with access as either as an ESTAR or PACE_MASTERDBO user. The Add Write Permissions command on the ribbon will grant this type of access and the Remove Write Permissions command will remove this access.
About the DB Users Audit Report
For a full audit history of any manage database user activity that occurred in User Administration, you can run an audit report in Eagle's System Management Center. Access System Management Center from the Eagle Navigator, click Diagnostics in the left navigation, click Queries, and select the UA Security - DB Users Administration Audit query.
You can manage Oracle database users as follows:
ACTION RULES BUTTON IS now disabled, not in QA yet as of 6-2-17. GET a new screenshot with Action Rules disabled
0 Comments