RE: How can I tell if a user has EXEC permission for a stored procedur

From: Mark Allison (marka_at_no.tinned.meat.mvps.org)
Date: 05/12/05

  • Next message: Stefan Berglund: "Re: SQL2KSP4 sp_addalias and db_accessadmin" 
    Date: Thu, 12 May 2005 09:02:04 -0700

    Hal

    Have a look at the sysprotects table - all the info you need is in there. If
    you need help with the query, post back. 

    -- 
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html 
"Hal Heinrich" wrote:
> Given a user-name and a stored procedure name, can someone provide me with 
> the TSQL code to set a boolean indicating whether that user has EXEC 
> permission to that proc?
> 
> The specific proc I'm interested in is xp_loginconfig.
> 
> Thanks in advance for your help,
> Hal Heinrich
> VP Technology
> Aralan Solutions Inc.
  • Next message: Stefan Berglund: "Re: SQL2KSP4 sp_addalias and db_accessadmin"

    Relevant Pages

    • Re: Another Concurrency Issue!!!!
      ... > allocating in blocks, using tables with identities, etc. ... > Columnist, SQL Server Professional ... I have a proc which returns a value after some DML operations on ... >> TIA ...
      (microsoft.public.sqlserver.programming)
    • Re: SQL 2005
      ... The SQL Server implementation is not just Stored Procs, ... it works very tightly in proc with the SQL Server Engine(most ... Now with all that I have said T-SQL is not going away and is still a needed ... >> the CLR is now supported in stored procedures and triggers. ...
      (borland.public.delphi.non-technical)
    • Re: Performance Problem Using ADO and Stored Procs
      ... >I have a stored proc that executes in < 15 seconds through Query Analyzer. ... If I execute this proc ... > of CPU activity on the server hosting SQL server for the SQL server ... > Private Function RunProc(vntDB As Variant, strProcName As String, ...
      (microsoft.public.data.ado)
    • Re: Stored proc timeout issue
      ... The program Opens the proc and times out after 2 minutes. ... proc from sql server mgmt studio, ... I began diagnosing the problem by commenting out various lines of code in the stored proc ... One thing that remained changed was the command timeout value. ...
      (borland.public.delphi.database.ado)
    • Re: Do UDFs slow down Stored Proc execution?
      ... Tuning the queries of course would be the correct thing to do. ... works beautifully from a business logic perspective. ... I have been plowing through the Microsoft SQL Server 2000 Performance ... I don't know if you actually want to see that proc. ...
      (microsoft.public.sqlserver.programming)