User does not have permission to alter database ‘%.*ls’.

Details
Product: SQL Server
Event ID: 5011
Source: MSSQLServer
Version: 8.0
Component: SQL Engine
Message: User does not have permission to alter database ‘%.*ls’.
   
Explanation
ALTER DATABASE permissions default to members of the sysadmin and dbcreator fixed server roles, and to members of the db_owner fixed database roles. These permissions are not transferable. For more information, see “ALTER DATABASE” in Books Online.
   
User Action
Log in as a member of the sysadmin or dbcreator fixed server roles or as a member of the db_owner fixed database role, and then reissue the ALTER DATABASE command.

Related:

Leave a Reply