Symptom
- Error 18225 is raised
- When trying to use sp_audit to set actions for a single login on all objects:
sp_audit 'insert','<login>','all','on'
Msg 18225, Level 16, State 1
Server 'ASE', Procedure 'sp_audit', Line 355
Login name must be 'all'.
or
sp_audit 'all', 'test_login_profile', 'all', 'on'
Msg 18224, Level 16, State 1:
Server 'ASE', Procedure 'sp_audit', Line 297:
'test_login_profile' is not a valid login name or role name.
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview