SAP Knowledge Base Article - Preview

1949781 - "manage database" permission is not enough to alter database - SAP ASE

Symptom

If we use the "Granular Permissions" feature in ASE and give a user "manage database permission" alter database command will fail with:

1> alter database dbname on dbdev = 10
2> go
Msg 10331, Level 14, State 1:
Server 'server name', Line 1:
Permission denied, database dbname, owner dbo. You need the following permission(s) to run this command: OWN DATABASE


Read more...

Environment

SAP Sybase Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

Granular Permissions, alter database , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.