Skip to Content
avatar image
Former Member

sp_displaylgin failed

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 13, 2016 at 05:32 PM

    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)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 14, 2016 at 02:48 PM

    Hello,

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

    Thank you for your answer,

    Add comment
    10|10000 characters needed characters exceeded