Re: Permissions List

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

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Fri, 28 Jun 2002 19:08:59 -0400

Alan,

Set up cursors to run through the users via the SET USER command, and put
all the information you get from the PERMISSIONS function into a table that
is keyed by user and table name. After the cursor has done its work, sort
the table by table name.

-------------------------------------------
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:1329e01c21ecb$8523de70$9ae62ecf@tkmsftngxa02...
> Thanks BP but I want the list by table not by user. I
> have almost 100 users and I am trying to get a handle on
> who has access to what tables.
>
> Alan
>
>
> >-----Original Message-----
> >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?
> >
> >
> >.
> >