SAP Knowledge Base Article - Preview

3312260 - sval in sysauditoptions does not change when using sp_audit - SAP ASE for BS

Symptom

  • Quering the sysauditoptions shows the following:

1> select * from sybsecurity.dbo.sysauditoptions where name in('sybase_ts_role')
2> go
num    val    minval maxval name                                                         sval                                                         comment                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        id          status
------ ------ ------ ------ ------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------- -----------
     25      0      0      3 sybase_ts_role                                               off                                                          TS role all-actions auditing 

  • Running the following commands sp_audit command to change audit option:

1> sp_audit 'all','sybase_ts_role','all',"on"
2> go
Audit option has been changed and has taken effect immediately.
(return status = 0)

  • Running the following command to display the audit option:


1> sp_audit 'all','sybase_ts_role','all'
2> go
Role auditing for 'all' is 'on'.
(return status = 0)

  • Querying sysauditsoption should show the sval as on but it ramains off:

1> use sybsecurity
2> go
1> select name, sval from sysauditoptions where name = "sybase_ts_role"
2> go
 name                                                         sval
 ------------------------------------------------------------ ------------------------------------------------------------
 sybase_ts_role                                               off

(1 row affected)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP NetWeaver (NW) - All versions

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR 824320, sval, sysauditoptions, 824320, sp_audit , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.