In Oracle, I granted select on a table to a user by giving the following command:

GRANT SELECT ON DEPT TO HOMERSIMPSON;

Once I granted a select on the dept table to homersimpson, I queried the dba_sys_privs, there's no record of the privilege granted. I used the following query:

Select * from dba_sys_privs where grantee = 'HOMERSIMPSON';

Why is the privilege not reported on this table?

Thanks in advance.

CodePudding user response：

You are granting a SELECT on a specific table. That's not a system priv. It is an object prv. Try looking at DBA_TAB_PRIVS.