Which user has which privileges 
Author Message
 Which user has which privileges
Hi

Is there an easy way to determine which user has which privileges?

TIA
Rene

Sent via Deja.com http://www.***.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 Which user has which privileges

dba_role_privs gives you the roles
dba_sys_privs gives you the system privileges
dba_tab_privs gives you the object privileges
dba_col_privs gives you the privileges on the columns

There is no easy way because a user may have a privilege
thru a role of a role of... but it can be done with SQL
and connect by clause.

--
Have a nice day
Michel



Quote:
> Hi

> Is there an easy way to determine which user has which privileges?

> TIA
> Rene

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Grant all Object Privilege from User to User

2. SQL Server 6.5 and sp_addlogin execute privileges for user not sa

3. Seeking query to display all users with sa privilege or sa equivalence

4. sa users lost privileges from SQL 6.0 to SQL 6.5

5. Changing User Privileges

6. SQL 6.5 User Privileges Unable to use Access 97 Nightmare

7. User Rights and Privileges

8. Granting a database user SA privileges

9. How to get a user's total privilege on objects of a database

10. User Privileges

11. User privileges

12. Create a user with 'sa' privileges


 
Powered by phpBB® Forum Software