Skip to Content
1

sp_displaylgin failed

Oct 13, 2016 at 05:01 PM

52

avatar image

Hello,

I'm trying to launch sp_displayaudit command in sysbase 15.7 but it throws the following error:

1> sp_displayaudit

2> go

Msg 2812, Level 16, State 5: Server 'xxxxxx', Line 1: Stored procedure 'sp_displayaudit' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output)

Am i missing something here, is there any previous action to be done?

Thank you

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Mark A Parsons Oct 13, 2016 at 05:32 PM
0

Have you created the sybsecurity database and run the installsecurity script? (sp_displayaudit is created by the installsecurity script) (see - http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc01672.1570/html/sec_admin/X42400.htm - for notes on installing Auditing)

If you have run the installsecurity script, have you verified that sp_displayaudit exists in the sybsytemprocs database? (eg, exec sybsystemprocs..sp_help sp_displayaudit)

Share
10 |10000 characters needed characters left characters exceeded
Erion Konomi Oct 14, 2016 at 02:48 PM
0

Hello,

I suspected that there was a previous step missing... i have not installed auditing.

Thank you for your answer,

Share
10 |10000 characters needed characters left characters exceeded