SAP Knowledge Base Article - Preview

3277237 - sp_displayaudit shows NULL entries in output column named "Subject Name" - SAP ASE

Symptom

  • Results in two NULL rows for Subject Name used to show sp_droplogin and drop login both have the issue
  • For example:  
sp_displayaudit
go
No sprocs/triggers currently have auditing enabled.
No databases currently have default sproc/trigger auditing enabled.
No objects currently have auditing enabled.
No databases currently have default table/view auditing enabled.
No logins currently have auditing enabled.
No databases currently have auditing enabled.
Audit Option                   Value                          Subject Name                   Type of Subject
------------------------------ ------------------------------ ------------------------------ --------------------
all                            on                             NULL                           login
all                            on                             NULL                           login


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 and above
  • SAP Adaptive Server Enterprise (ASE) 16.0 SP04 and above

Product

SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.