SAP Knowledge Base Article - Preview

3658780 - Error 19354 when executing sp_dboption - SAP ASE

Symptom

  • Error 19354 when executing sp_dboption
  • Example:
    1> sp_dboption sybsecurity,'ddl in tran', false
    2> go
    Running CHECKPOINT on database 'sybsecurity' for option 'ddl in tran' to take effect.
    Msg 10331, Level 14, State 1:
    Procedure 'sp_dboption', Line 1528:
    Permission denied, database master, owner dbo. You need the following permission(s) to run this command: OWN DATABASE or MANAGE SERVER.
    Database option 'ddl in tran' turned OFF for database 'sybsecurity'.
    (return status = 0)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.x
  • sp_dboption is being executed from within the master database 

Product

SAP Adaptive Server Enterprise all versions

Keywords


error 19354, sp_dboption, permission denied, sybsecurity database, ddl in tran, CR 830827, database master, database owner, manage server, SAP Adaptive Server Enterprise, database option error , 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.