Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

turn on audit on my procs

6 posts in General Discussion Last posting was on 2010-03-26 12:10:20.0Z
Ignacio Posted on 2010-03-25 17:48:54.0Z
Sender: 772d.4baba076.1804289383@sybase.com
From: Ignacio
Newsgroups: sybase.public.ase.general
Subject: turn on audit on my procs
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4baba206.778d.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 25 Mar 2010 09:48:54 -0800
X-Trace: forums-1-dub 1269539334 10.22.241.41 (25 Mar 2010 09:48:54 -0800)
X-Original-Trace: 25 Mar 2010 09:48:54 -0800, 10.22.241.41
Lines: 3
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29072
Article PK: 78311

Do you know how can I turn on "execute" auditing of each of
my stored procedures?
version ase 12.5.2


Carl Kayser Posted on 2010-03-25 18:16:58.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.general
References: <4baba206.778d.1681692777@sybase.com>
Subject: Re: turn on audit on my procs
Lines: 7
Organization: BLS
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4baba89a$1@forums-1-dub>
Date: 25 Mar 2010 10:16:58 -0800
X-Trace: forums-1-dub 1269541018 10.22.241.152 (25 Mar 2010 10:16:58 -0800)
X-Original-Trace: 25 Mar 2010 10:16:58 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29073
Article PK: 78310


<Ignacio> wrote in message news:4baba206.778d.1681692777@sybase.com...
> Do you know how can I turn on "execute" auditing of each of
> my stored procedures?
> version ase 12.5.2


Carl Kayser Posted on 2010-03-25 18:22:55.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.general
References: <4baba206.778d.1681692777@sybase.com>
Subject: Re: turn on audit on my procs
Lines: 14
Organization: BLS
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4baba9ff$1@forums-1-dub>
Date: 25 Mar 2010 10:22:55 -0800
X-Trace: forums-1-dub 1269541375 10.22.241.152 (25 Mar 2010 10:22:55 -0800)
X-Original-Trace: 25 Mar 2010 10:22:55 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29074
Article PK: 78312


<Ignacio> wrote in message news:4baba206.778d.1681692777@sybase.com...
> Do you know how can I turn on "execute" auditing of each of
> my stored procedures?
> version ase 12.5.2

sp_audit exec_procedure, 'all', <SP>, 'on'

or

sp_audit exec_procedure, 'all', 'default procedure', 'on' will set auditing
for any SPs created after this sp_audit command is run.


Ignacio Posted on 2010-03-25 19:58:46.0Z
Sender: 772d.4baba076.1804289383@sybase.com
From: Ignacio
Newsgroups: sybase.public.ase.general
Subject: Re: turn on audit on my procs
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4babc075.7cf7.1681692777@sybase.com>
References: <4baba9ff$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 25 Mar 2010 11:58:46 -0800
X-Trace: forums-1-dub 1269547126 10.22.241.41 (25 Mar 2010 11:58:46 -0800)
X-Original-Trace: 25 Mar 2010 11:58:46 -0800, 10.22.241.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29075
Article PK: 78314

thanks I applied the command , can you let me know now where
can I find information about the executed procs?

regards

> <Ignacio> wrote in message
> > news:4baba206.778d.1681692777@sybase.com... Do you know
> > how can I turn on "execute" auditing of each of my
> > stored procedures? version ase 12.5.2
>
> sp_audit exec_procedure, 'all', <SP>, 'on'
>
> or
>
> sp_audit exec_procedure, 'all', 'default procedure', 'on'
> will set auditing for any SPs created after this sp_audit
> command is run.
>
>


Michael Peppler [Team Sybase] Posted on 2010-03-26 05:53:20.0Z
From: "Michael Peppler [Team Sybase]" <mpeppler@peppler.org>
Organization: Peppler Consulting SARL
Subject: Re: turn on audit on my procs
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2010.03.26.05.53.18.498776@peppler.org>
Newsgroups: sybase.public.ase.general
References: <4baba9ff$1@forums-1-dub> <4babc075.7cf7.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 25 Mar 2010 21:53:20 -0800
X-Trace: forums-1-dub 1269582800 10.22.241.152 (25 Mar 2010 21:53:20 -0800)
X-Original-Trace: 25 Mar 2010 21:53:20 -0800, vip152.sybase.com
Lines: 28
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29077
Article PK: 78313

In the sybsecurity database, in the sysaudits_xx table(s) (where xx is a
number depending on the current audit table)

Michael

On Thu, 25 Mar 2010 11:58:46 -0800, Ignacio wrote:

> thanks I applied the command , can you let me know now where
> can I find information about the executed procs?
>
> regards
>
>> <Ignacio> wrote in message
>> > news:4baba206.778d.1681692777@sybase.com... Do you know
>> > how can I turn on "execute" auditing of each of my
>> > stored procedures? version ase 12.5.2
>>
>> sp_audit exec_procedure, 'all', <SP>, 'on'
>>
>> or
>>
>> sp_audit exec_procedure, 'all', 'default procedure', 'on'
>> will set auditing for any SPs created after this sp_audit
>> command is run.
>>
>>


Carl Kayser Posted on 2010-03-26 12:10:20.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.general
References: <4baba9ff$1@forums-1-dub> <4babc075.7cf7.1681692777@sybase.com>
Subject: Re: turn on audit on my procs
Lines: 30
Organization: BLS
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4baca42c$1@forums-1-dub>
Date: 26 Mar 2010 04:10:20 -0800
X-Trace: forums-1-dub 1269605420 10.22.241.152 (26 Mar 2010 04:10:20 -0800)
X-Original-Trace: 26 Mar 2010 04:10:20 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29078
Article PK: 78315


<Ignacio> wrote in message news:4babc075.7cf7.1681692777@sybase.com...
> thanks I applied the command , can you let me know now where
> can I find information about the executed procs?
>

See chapter 11 at
http://infocenter.sybase.com/help/topic/com.sybase.dc31654_1251/pdf/sag.pdf.
I don't know if there should be any additions to table 11-3 for ASE 12.5.2.
(Probably not.)


> regards
>
>> <Ignacio> wrote in message
>> > news:4baba206.778d.1681692777@sybase.com... Do you know
>> > how can I turn on "execute" auditing of each of my
>> > stored procedures? version ase 12.5.2
>>
>> sp_audit exec_procedure, 'all', <SP>, 'on'
>>
>> or
>>
>> sp_audit exec_procedure, 'all', 'default procedure', 'on'
>> will set auditing for any SPs created after this sp_audit
>> command is run.
>>
>>