Re: USER_SYS_PRIVS and DBA_SYS_PRIVS

Hello,

This is because USER_SYS_PRIVS contains information about only system privileges, but not roles. You may what to take a look at USER_ROLE_PRIVS, from there you will see CONNECT and RESOURCE roles under the column GRANTED_ROLE.

If you want to see what system privileges have been granted to a role, I think you can join the USER_ROLE_PRIVS and ROLE_SYS_PRIVS views to obtain these information.

cheers,
geoffrey

suisum_at_ecn.ab.ca wrote:
>
> 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:45:11 CST