SELECT /*+ RULE */ grantee, granted_role
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.
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)