Re: Auditing SP Execute.

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/23/05

  • Next message: Kevin McDonnell [MSFT]: "Re: MBSA 1.2 and slammer" 
    Date: Wed, 23 Feb 2005 17:20:44 -0500

    Ahh yes. My original reading was he was looking to trace the sp_executesql
    sp but I think I was mistaken. If it is a user sp then sure. 

    -- 
Andrew J. Kelly  SQL MVP
"Jasper Smith" <jasper_smith9@hotmail.com> wrote in message 
news:OcM6uPfGFHA.3076@tk2msftngp13.phx.gbl...
> As long as the users only have execute permissions on the proc i.e. they 
> can't change it, then just add some code at the start of the proc to log 
> to a table passing getdate() and suser_sname() to capture the time and 
> user executing the proc. This assumes that the app doesn't use a single 
> service account (in which case you won't be able to get the user name 
> without modifying the app to stuff it into context_info)
>
> -- 
> HTH
>
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Pranay Pandya" <ppandya@gmail.com> wrote in message 
> news:1109178725.456740.135850@z14g2000cwz.googlegroups.com...
>> To meet audit requirements, I have to maintain an audit log of when a
>> particular sp was execute and by whom.  I am not willing to use the c2
>> option for just one stored procedure.  There are 2 users who can run
>> the stored procedure from enterprise manager or query analyser (others
>> run it from an app). Any suggetions?
>> Thank You,
>> -pranay
>>
>
>
  • Next message: Kevin McDonnell [MSFT]: "Re: MBSA 1.2 and slammer"

    Relevant Pages

    • 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: Auditing SP Execute.
      ... As long as the users only have execute permissions on the proc i.e. they ... This assumes that the app doesn't use a single service ... > the stored procedure from enterprise manager or query analyser (others ...
      (microsoft.public.sqlserver.security)
    • Re: DTS and MSDE
      ... that does the calling of the package as the package runs from the place calling ... I will presume that the package is stored on a SQL Server somewhere. ... The above error is not appearing the in the vb app (removed error ... I've even used the "sa" login to execute the dts pkg and still ...
      (microsoft.public.sqlserver.dts)
    • 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 process. ...
      (microsoft.public.data.ado)
    • Re: sp_start_job : Launching external apps
      ... All I'm doing is running a app that creates a flat file. ... Jobs are execute by SQL Server agent. ... > I'm trying to launch a VB application from a job I created. ...
      (microsoft.public.sqlserver.programming)