Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

PLEASE REVIEW THE TEXT IN THIS PAGE, PARTICULARLY THE TEXT IN RED.

To enable the database user management 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 (DEV, TEST, PROD) via Sys Item 201Depending 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

For In DB Users workspace, for DEV environments only (Sys Item 201=DEV), you can also use the proxy feature (Add write permissions Write Permissions and Remove write permissionsWrite Permissions) to connect to the database with access as either as an ESTAR or PACE_MASTERDBO user. To connect with this type of access, users have to be granted appropriate permissions in User Administration. The Add Write Permissions command should be applied in the DB Users window. The on the ribbon will grant this type of access and the Remove Write Permissions command should be used to will remove this access. New DB Users are now assigned to predefined DB Roles which are selected according to Sys Item 201 which specifies whether it is a DEV, TEST, or PROD system. Additionally, the EA_PROFILE profile is now applied when a new DB user is created.

About the DB Users Audit Report

...