I have a user that is a security admin in the I.t. dept. I need to grant his Oracle user account privileges to be able to create new users, change passwords and change membership in other groups we created. This is basically a security admin that I do not want to give full sysdba/dba privileges to. That would be overkill. What exactly do I grant and how?
Oracle – How to grant a user permission to create and change passwords for other users (like a security admin)
oracleSecurity
Related Question
- Virtual Private Database: Create Policy function/s so that a user can view his own records or records inserted by other users with the same company ID
- Postgresql – Revoke grant option from table owner
- Oracle – User to not see data from other users
- Tyring to get a better understanding of ORACLE admin accounts
- ORA-01017: invalid username/password; cannot login with other users except sys user, Oracle Database 12c
- ORA 01031 Insufficient privileges on GRANT SELECT on ALL_CATALOG to a user as system user
- How to grant SYSDBA access to users on Oracle Cloud v19c
Best Answer
You just need to GRANT them the CREATE USER and ALTER USER system privileges.
E.g:
GRANT ALTER USER TO UserAccountWithPermission;