USER_SYS_PRIVS and DBA_SYS_PRIVS

Hi:

I wonder why if system privileges are granted through roles, the privileges didn't show in USER_SYS_PRIVS. But the privileges are shown in DBA_SYS_PRIVS. So the user has to use ROLE_SYS_PRIVS to see what system privileges they have.

I grant a user with CONNECT and RESOURCE roles. The USER_SYS_PRIVS only contains one entry, that is UNLIMITED TABLESPACE. But in DBA_SYS_PRIVS, it shows a list of system privileges. When I select from ROLE_SYS_PRIVS, it shows a list of system privileges for the user.

From somewhere, I read that the data for ALL_, USER_ and DBA_ view should be the same. Except the view is either for a particular user, or for dba, or for all. But there is no ALL_SYS_PRIVS. Received on Sun Jan 03 1999 - 23:21:04 CST