S04004

Error Code

S04004

Error Message

Non-admin users cannot {action} the {prev} privilege. Contact the administrator. RefId: S04004

Probable Causes

This error occurs when setting privileges other than the following ones to non-admin users:

  • TABLE_READ

  • TABLE_WRITE

  • TABLE_INSERT

  • TABLE_UPDATE

  • TABLE_DELETE

  • DB_READ

  • DB_WRITE

  • DB_INSERT

  • DB_UPDATE

  • DB_DELETE

  • DBOBJ_DELETE

  • DBOBJ_CREATE

  • VIEW_EXEC

Solutions

Non-admin users can only be granted the aforementioned 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.