Question about user_sys_privs
I have a customer who is granting priveleges to a schema. He then queries user_sys_privs but the table is blank and the schema has no priveleges still. Shouldn't the priveleges show up in user_sys_privs ?
SQL> grant select any table to am_agent;
Grant succeeded.
SQL> select * from user_sys_privs where username = 'AM_AGENT';
no rows selected
SQL> show user
USER is "SYSTEM"
0