On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-00601 -- GAUSS-00700/ GAUSS-00621 -- GAUSS-00630

GAUSS-00621 -- GAUSS-00630

Updated on 2024-03-15 GMT+08:00

View PDF

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.

Parent topic: GAUSS-00601 -- GAUSS-00700

Previous topic: GAUSS-00611 -- GAUSS-00620

Next topic: GAUSS-00631 -- GAUSS-00640

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel