...
...
In addition to System Administrators, it is also possible to grant Advanced Users associated with a specific User Administrative Role access to DB Users functionality.
| Warning |
|---|
The ability to allow Advanced Users with specific User Administrative Roles to access DB Users is as of V2015R2.11. Prior to this version, you must be a System Administrator as there was an issue that did not allow Advanced Users to see the DB Users area under User Administration Setup even if they were granted the appropriate permissions. |
...
...
In the example below, the user is an Advanced User who has the User Administrative Role of "DB USERS LOCK-UNLOCK ONLY".
...
Control Environment Access via Sys Item 201
You can 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. 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.
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.