Application DBAs should have access to the Performance and Schema Management pages in Enterprise manager.
Creating an Application DBA Account
To create an application DBA account in Enterprise Manager:
- Follow the instructions in "Creating a New Administrator" to create an Enterprise Manager administrator.
- Grant the privilege Database Application DBA on the database target.
- Grant the Full privilege on the database host target.
- Using the Resource Privileges Page, grant the Create New Named Credentials privilege on the Named Credential Resource Type privilege page and Create Privilege on Job System Resource Type privilege.
Creating Named Credentials
To create named credentials, the database administrator can create their own named credential or it can be created by the super administrator (or a privileged Administrator with the system resource privilege) and then granted to the application DBA. The named Credential is granted the view privilege on the named credential so that the application DBA does not even know or see the contents of the named credential.