Re: object permissions t-sql cmd

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 03/25/04


Date: Thu, 25 Mar 2004 20:23:57 -0000

Have a look at sp_helprotect in BOL

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Rob" <anonymous@discussions.microsoft.com> wrote in message
news:13c4f01c412a4$7933a220$a101280a@phx.gbl...
> Hello:
>
> Does anyone know of a command to view all the object
> permissions of a particular user (select, insert,...)?
>
> Thanks.
>
> - Rob.


Relevant Pages

  • Re: Number of left joins allowed in query
    ... > Dear Rob: ... > and use a SQL Server query. ... You may need to buy the SQL Server Developer Edition ... >>> exploratory work. ...
    (microsoft.public.access.queries)
  • Re: Whats My Password?
    ... Rob MacDonald. ... Don't assume the ISP has any DBMS. ... Hitchhiker's Guide to Visual Studio and SQL Server ... to access any selected DBMS engine that has a .NET Provider of some kind. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How can I use MDX functions in SQL Query Analyzer (Client Tool)
    ... Jasper Smith (SQL Server MVP) ... community for SQL Server professionals - ... > somethingI need to enable, install, configure, tweek, activate, ...
    (microsoft.public.sqlserver.clients)
  • Re: Another 17055 error problem
    ... Jasper Smith (SQL Server MVP) ... >>That just looks like you have Auditing set to either ... >>community for SQL Server professionals - ...
    (microsoft.public.sqlserver.security)
  • Re: JOBS
    ... >Jasper Smith (SQL Server MVP) ... >community for SQL Server professionals - ... >>Give the user in question permission to exec these procs. ...
    (microsoft.public.sqlserver.security)