HELP audit a specific user in a database

Hello

I need to set audit in Sybase for some users only. How can I setup
audit for a database and a user on delete, truncate etc

The following commands do it for the database entire users which I
don't want to do

Use mydb
Go

sp_audit "delete" , "all" , "default table" , "on"
go
This audits all users in mydb, but I want to audit only test_dbo is
this possible? If so how?
If I set up under the sybsecurity the following does not capture
everything
sp-audit "all", "test_dbo", "all", "on"
go


I have tried around with different commands but no luck


Thanks
Maria

Carl Kayser wrote:
> wrote in message
>
> > Hello
> >
> > I need to set audit in Sybase for some users only. How can I setup
> > audit for a database and a user on delete, truncate etc
> >
> > The following commands do it for the database entire users which I
> > don't want to do
> >
> > Use mydb
> > Go
> >
> > sp_audit "delete" , "all" , "default table" , "on"
> > go
> > This audits all users in mydb, but I want to audit only test_dbo is
> > this possible? If so how?
> > If I set up under the sybsecurity the following does not capture
> > everything
> > sp-audit "all", "test_dbo", "all", "on"
> > go
> >
> >
> > I have tried around with different commands but no luck
> >
> >
> > Thanks
> > Maria
> >
>
> Let's get clear on what you want. You want to audit login test_dbo but only
> in database mydb. Assuming this you could make a login that has access only
> to mydb (e.g., test_dbo_mydb) and audit the login. However I suspect that
> activites as a guest user in sybsystemprocs, master, etc would also be
> audited.
>
> 'the following does not capture everything sp_audit "all", "test_dbo",
> "all", "on"'
> What isn't captured? What ASE version are you running?


I'm running ASE 12.5.3 on solaris 5.8

what im doing is the following
use mydb
go
sp_audit "delete", "all" "default table", "on" (this works but
audits evey user on mydb and not a specific user

what I want is


1> sp_audit "delete", "test_dbo", "default table", "on"
2> go
Msg 18225, Level 16, State 1:
Procedure 'sp_audit', Line 332:
Login name must be 'all'.
(return status = 1)