S04005

Error Code

S04005

Error Message

To manage permissions for databases you didn't create, you must have the DB_MANAGE privilege or contact an administrator. RefId: S04005

Probable Causes

This error occurs when non-admin users attempt to manage privileges for databases they have no permission for.

Solutions

Non-admin users can only be set the following privileges and the permission scope can be global (*). Users must also have the corresponding permission for objs, as shown in the following table:

Privilege Type Required Permission
  • TABLE_READ
  • TABLE_WRITE
  • TABLE_INSERT
  • TABLE_UPDATE
  • TABLE_DELETE
 Users must have the DB_MANAGE privilege for the database where the specified table is located, or be the creator of the database.
  • DB_READ
  • DB_WRITE
  • DB_INSERT
  • DB_UPDATE
  • DB_DELETE
  • DBOBJ_DELETE
  • DBOBJ_CREATE
 Users must have the DB_MANAGE privilege for the specified database, or be the creator of the database.
  • VIEW_EXEC
 Users must have the VIEW_OWNER privilege and be the creator of the specified function view.