Thursday, March 8, 2012

Audit V2

I am looking to write a SQL script that will show me for each table, in all
the databases on a server, which users / groups have access. In addition, I
want to break the access into whether it is SELECT, UPDATE, INSERT or DELETE
permissions.
Is this possible?Justin
See sp_helprolemember and sp_helprotect system stored procedures
Read "Denying Permissions" in the BOL
"Justin" <none@.none.com> wrote in message
news:UpqdnWoastaMtYHfRVn-1g@.is.co.za...
> I am looking to write a SQL script that will show me for each table, in
all
> the databases on a server, which users / groups have access. In addition,
I
> want to break the access into whether it is SELECT, UPDATE, INSERT or
DELETE
> permissions.
> Is this possible?
>

No comments:

Post a Comment