Beginners oracle database, login sys account, log in as a sysdba,
Query: select * from dba_sys_privs; Can normal query results,
But the query: select * from all_sys_privs, error: ORA - 00942, table or view does not exist,
Surf the Internet query along while, also didn't understand the reason, I hope masters teach under
CodePudding user response:
All_sys_privs itself does not exist, role authorization also does not have all the views of one class, only the permissions object has all the view at this level,CodePudding user response:
Oh, oh, the original is such, thank you very much, new feeling small white into the doors are good laborious