Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Grant select any dictionary

under_sunJan 4 2018 — edited Jan 4 2018

hi people , how are you all?

i have simple question , what is the thing i am missing here

  1* create user c##user1 identified by user1 default tablespace users quota unlimited on users

SQL> /

User created.

grant create session , select any dictionary to c##user1 container=all;

Grant succeeded.

SQL> connect c##user1/user1

Connected.

SQL>  select pdb_name ,status from cdb_pdbs;

no rows selected

isn't select any dictionary supposed to grant (  c##user1 )  accessibility to dictionary tables ?

thank you all.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2018
Added on Jan 4 2018
6 comments
4,225 views