Oracle: Granting Select Any Table Doesn't Show up in Dba_Tab_Privs
I Have an Issue Where I (As Sysdba) Granted a Privilege to Perform a Select on Any Table to a User. I Used the Following Query: Grant Select Any Table to...
I have an issue where I (as sysdba) granted a privilege to perform a select on any table to a user. I used the following query:
GRANT SELECT ANY TABLE TO BARTSIMPSON
I get the message that grant succeeded. But I don't see a record of this privilege in the dba_tab_privs. Why? Thanks in advance
1 Answer
You are looking in the wrong view. dba_tab_privs shows table privileges. select any table is a system privilege. You should look for it in dba_sys_privs.
Alexander Ross has covered the video game industry for a decade, writing deep dives on game design, esports tournaments, VR developments, and gaming culture.
