Re: Permissions List

From: BP Margolin (bpmargo@attglobal.net)
Date: 06/28/02 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Fri, 28 Jun 2002 13:16:52 -0400

Alan,

Perhaps you could play with a combination of the SET USER command and the
PERMISSIONS function to accomplish what you want.

Documentation on both SET USER and PERMISSIONS is available in the SQL
Server Books Online.

You might also use SQL Server Profiler to trace the commands used by
Microsoft to determine permissions within Enterprise Manager.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Alan Roberts" <taroberts@gcc.edu> wrote in message
news:1326f01c21ec6$7e194b60$9ae62ecf@tkmsftngxa02...
> How can I get a printable list of all users who have
> access to a particular table?

Relevant Pages