Updated on 2023-12-22 GMT+08:00

GAUSS-00621 -- GAUSS-00630

GAUSS-00621: "column names cannot be included in GRANT/REVOKE ROLE"

SQLSTATE: 0LP01

Description: The GRANT/REVOKE ROLE statement contains column names.

Solution: Ensure that the GRANT/REVOKE ROLE statement does not contain column names.

GAUSS-00622: "Permission denied to drop objects."

SQLSTATE: 42501

Description: You have no permission to delete objects owned by users.

Solution: Ensure that you have the permission to perform such an operation.

GAUSS-00623: "Permission denied to reassign objects."

SQLSTATE: 42501

Description: You have no permission to assign objects for users.

Solution: Ensure that you have the permission to perform such an operation.

GAUSS-00624: "must be system admin user to alter system admin users"

SQLSTATE: 42501

Description: You have no permission to modify system administrators.

Solution: Modify system administrators as a system administrator.

GAUSS-00625: "must have admin option on role '%s'"

SQLSTATE: 42501

Description: A system administrator does not have the SYSADMIN attribute.

Solution: When creating a system administrator, specify the SYSADMIN attribute for it.

GAUSS-00626: "must be system admin to set grantor"

SQLSTATE: 42501

Description: You have no permission to set authorizers.

Solution: Set authorizers as a system administrator.

GAUSS-00627: "role '%s' is a member of role '%s'"

SQLSTATE: 0LP01

Description: The target user is a member of a user.

Solution: Check whether the target user is a member of a user.

GAUSS-00628: "schema '%s' doesnot exist"

SQLSTATE: 3F000

Description: The schema does not exist.

Solution: Check whether the schema exists.

GAUSS-00629: "cannot cancel current session's query"

SQLSTATE: 42601

Description: The session query cannot be canceled.

Solution: Check whether the session has locked the objects owned by users.

GAUSS-00630: "md5-password encryption failed."

SQLSTATE: XX000

Description: MD5 fails to encrypt passwords.

Solution: Contact technical support.