Re: Permissions List
From: Roy Harvey (RoyHarv@compuserve.com)
Date: 06/28/02
- Next message: Sue Hoegemeier: "Re: Permissions List"
- Previous message: Anith Sen: "Re: Permissions List"
- In reply to: Alan Roberts: "Permissions List"
- Next in thread: Sue Hoegemeier: "Re: Permissions List"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Roy Harvey <RoyHarv@compuserve.com> Date: Fri, 28 Jun 2002 15:05:48 -0400
Alan,
>How can I get a printable list of all users who have
>access to a particular table?
You can get the first level of this by running sp_helprotects, with
the table name as a parameter. Remember that the source code for the
system procs can be found in the master database.
As for turning the group names into user names, I'm not much help.
Roy
- Next message: Sue Hoegemeier: "Re: Permissions List"
- Previous message: Anith Sen: "Re: Permissions List"
- In reply to: Alan Roberts: "Permissions List"
- Next in thread: Sue Hoegemeier: "Re: Permissions List"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
