Re: Permissions List

From: Alan Roberts (taroberts@gcc.edu)
Date: 06/28/02 

From: "Alan Roberts" <taroberts@gcc.edu>
Date: Fri, 28 Jun 2002 10:44:58 -0700

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: What commands can a user execute
    ... simple security query rather than BOL. ... example would be the command UPDATE STATISTICS. ... ALTER permissions on the table or view. ... you could retrieve this with a query from SQL Server rather than Books ...
    (microsoft.public.sqlserver.security)
  • Re: What commands can a user execute
    ... example would be the command UPDATE STATISTICS. ... ALTER permissions on the table or view. ... you could retrieve this with a query from SQL Server rather than Books ...
    (microsoft.public.sqlserver.security)
  • Re: VS 2003 & SQL 2005 Data Adapter Error
    ... I think some playing around with permissions might be in order here. ... The error code you shows means that the connection for the ... I select "Use SQL Staements" ... Generated SELECT Command ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: COBOL stored procedure for DB2
    ... Regarding how you precompile the app, you must specify target mfcob to db2 prep, rather than target ibmcob. ... Have you also confirmed that, prior to executing the CALL statement, the host variables specified within the client app have the appropriate values? ... MODIFIES SQL DATA ... confirm the cob command used for creating the SP module. ...
    (comp.lang.cobol)
  • Re: SQL CE Synching Problems
    ... Have you granted IUSER_ServerName access to your publication within SQL ... It looks like the permissions problem is getting access to the publication. ... so the issue has to be between the server tools and the publisher. ... > A request to send data to the computer running IIS has failed. ...
    (microsoft.public.sqlserver.ce)