SAP Knowledge Base Article - Preview

2018481 - Feature Request: Msg 18225: Unable to set audit options for a single login - SAP ASE

Symptom

Error 18225 is raised when trying to use sp_audit to audit actions for a single login on all objects:

sp_audit 'insert','<login>','all','on'

Msg 18225, Level 16, State 1
Server '<servername>', Procedure 'sp_audit', Line 355
Login name must be 'all'.
(return status = 1)

or

sp_audit 'all', 'test_login_profile', 'all', 'on'

Msg 18224, Level 16, State 1:
Server '<servername>', Procedure 'sp_audit', Line 297:
'test_login_profile' is not a valid login name or role name.
(return status = 1)


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) All Versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

granular, auditing, sp_audit, login, 18225, 18224 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.