Re: USER_SYS_PRIVS and DBA_SYS_PRIVS

Hi Geoffrey:

Thanks a lot for your reply.

Actaully, my question is in name convention of the view. Consider the following:

  ALL_TABLES  - Table objects the user can access.
  USER_TABLES - Table objects owned by the user.
  DBA_TABLES  - All table objects in the database.

But I can't apply this name convention for _SYS_PRIVS view.

Thanks,

Geoffrey Hui (geoffreyh_at_fujitsu.com.hk) wrote:

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

: suisum_at_ecn.ab.ca wrote:
: >
: > 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 Mon Jan 04 1999 - 09:48:20 CST