System Administrators can manage all aspects of the Managing Oracle Database Users functionality.
To check whether a user is a System Administrator, look at the Functional Access tab and see if System Administrator is checked as the Account Type.
In addition to System Administrators, it is also possible to grant Advanced Users associated with a specific User Administrative Role access to Manage Oracle Database Users.
The ability to allow Advanced Users with specific User Administrative Roles access to Manage Oracle Database Users is as of v2015R2.11.Prior to this version, you must be a System Administrator as there was a bug that did not allow Advanced Users to see the Manage DB Users section under Setup even if they were granted the appropriate permissions.
On the User Administrative Role level, you can specifically grant users who have this role access to any or all of the following: View DB Users, Create DB Users, Edit DB Users, Lock/Unlock DB Users, Delete DB Users.
For example, in the screenshot below the user is an Advanced User and has the the User Administrative Role of "DB USERS LOCK-UNLOCK ONLY".
Under the User Administrative Roles section, you can see that the role of "DB USERS LOCK-UNLOCK ONLY" has been granted rights to View DB Users and Lock/Unlock DB Users only in this example:
back to top
Manage space
Manage content
Integrations
Add Comment