Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

In a non CDB 12c database, DBA_ROLE_PRIVS.COMMON has 'YES' values for grantee 'SYS' with some grante

ThilinaaAug 22 2014 — edited Aug 24 2014

SELECT /*+ RULE */ grantee, granted_role

      FROM   sys.dba_role_privs

      WHERE  grantee LIKE 'SYS'

      AND    default_role = 'YES'

This query returns two rows with one Common value one set to YES ans other set to NO as follows.

SYSJAVAIDPRIVYESYESNO
SYSJAVAIDPRIVNOYESYES
GranteeGranted_RoleAdmin_OptionDefault_RoleCommon

 

Facts: SELECT CDB FROM V$DATABASE; returns NO

          SELECT CON_ID, CON_UID FROM V$CONTAINERS ORDER BY CON_ID;  returns 0,0

What I want to clarify is, while this is being a non container database, what is the meaning of Common = Yes.

(I posted this initially in here

As rp0428 has said I posted this in this forum, but i can't mark that discussion as ANSWERED because it has been locked. I don't know why it has been locked)

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2014
Added on Aug 22 2014
2 comments
1,405 views