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.
SAP Knowledge Base Article - Preview