Users management
Query USER PRIVILEGES replicated
With the article Query USER PRIVILEGES replicated, we can retrieve all ROLES, system PRIVILEGES, and object PRIVILEGES of a USER and construct the GRANT command assigning them to another USER. When a user is created in the Oracle database, if no roles or privileges are assigned, the user will not Read more…