Database Administration (MOSC)

MOSC Banner

Oracle SYSAUTH# table question

edited Jan 2, 2024 8:57PM in Database Administration (MOSC) Question

Hello All,

Happy New year.

Quick question. Running oracle 19c in multitenant architecture. These where migrated originally from 11 to 12c multitenant via import. They have since migrated via clone.

My question is when running some checks and I came across a common and non-common privilege granted via role. I just used -250 and -257 in the query to keep the results low.

SQL> SELECT *

 2   FROM dba_sys_privs

 3   WHERE grantee = 'AQ_ADMINISTRATOR_ROLE'

 4* ORDER BY 2,3,4;


         GRANTEE          PRIVILEGE  ADMIN_OPTION  COMMON  INHERITED

________________________ ____________________________ _______________ _________ ____________

AQ_ADMINISTRATOR_ROLE  CREATE EVALUATION CONTEXT  YES       NO    NO

AQ_ADMINISTRATOR_ROLE  CREATE EVALUATION CONTEXT  YES       YES    YES

AQ_ADMINISTRATOR_ROLE  CREATE RULE         YES       NO    NO

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center