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: 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

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

enter image description here

1

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.

ncG1vNJzZmirpJawrLvVnqmfpJ%2Bse6S7zGiorp2jqbawutJobXJrZGWGeoSOqKmam5yaeqi%2BwKeroqaXYsCmuMScq2aZnq56ta3BpZxmnJ%2BawK%2FAjKyfqK9dqr1utc1mm5uZXamuo3nPq6Cvqw%3D%3D

 Share!