Audit V2

External Since: Jan 10, 2005 Posts: 4

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?

External Since: Aug 24, 2003 Posts: 1744

Justin
See sp_helprolemember and sp_helprotect system stored procedures

Read "Denying Permissions" in the BOL

"Justin" wrote in message

> 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?
>
>