How to change database ownership in Sybase

SAP ASE database ownership can changed using sp_changedbowner system stored procedure.

Syntax:
sp_changedbowner loginame [, true ]

Example:

1> use k2admin
2>go
1> sp_changedbowner admin
2> go

How to change database ownership in Sybase

Conditions to change the Database owership:

  • System stored procedure sp_changedbowner must be executed from within the database whose owner we want to change.
  • The new owner must not already be a user in the database.
  • System administrator only can execute sp_changedbowner.

To know the database owner execute sp_helpdb stored procedure.

Related Posts

You can leave a response, or trackback from your own site.

Leave a Reply

Powered by k2schools