Re: Permissions List

From: Anith Sen (anith@bizdatasolutions.com)
Date: 06/28/02 

From: "Anith Sen" <anith@bizdatasolutions.com>
Date: Fri, 28 Jun 2002 13:36:10 -0500

Something along the lines of ...

SELECT
    sysobjects.[name],
     sysusers.[name] as [User],
     syspermissions. *
FROM
     syspermissions inner join sysobjects
          on syspermissions.id = sysobjects.id
    INNER JOIN sysusers
  on syspermissions.grantee = sysusers.uid
WHERE
     sysobjects.name = '<yourTable>'

??
- Anith

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

Relevant Pages

  • RE: Cursor Not Running Correctly.. Need Help/Suggestions...
    ... if it is a permission issue, which permissions would you think need to be ... being used/checked when the trigger get's called.. ... >> INNER JOIN Orders ...
    (microsoft.public.sqlserver.programming)
  • Re: Pre snapshot to apply permissions
    ... Very good, Paul. ... > here is a script I use which can be adapted for your needs. ... > INNER JOIN delivery.dbo.sysextendedarticlesview ON ... >> permissions. ...
    (microsoft.public.sqlserver.replication)