User/Role Privileges

mike123abc · July 7th, 2004, 02:15 AM

Hi,

I need to read and subsequently modify the privileges (rights) of a certain SQL Server user / role from within a Visual Basic Program.

Modifying seems to be easy using standard statements like GRANT/REVOKE. But what about reading all the rights a user has ?

I have researched SQL-DMO, but didn't find what I'm looking for.

Any idea ?

Mike

melvik · July 7th, 2004, 03:07 AM

Try:

Code:

SELECT sysusers.Name ,syspermissions.*
FROM   syspermissions INNER JOIN sysusers ON Grantee = UId

HTH.

Always:),
Hovik Melkomian.