Help Center/
Data Warehouse Service /
Troubleshooting/
Account/Permission/Password/
An Error Message Is Reported During Statement Execution, Indicating that the User Does Not Have the Required Permission
Updated on 2025-09-19 GMT+08:00
An Error Message Is Reported During Statement Execution, Indicating that the User Does Not Have the Required Permission
Symptom
The following error message is displayed after statement execution.
1
|
ERROR: permission denied for xxx |
Possible Causes
The user does not have the corresponding permission and cannot access or perform operations on the table or schema.
Handling Procedure
- Grant permissions to tables or schemas using GRANT. If you want user jerry to have the query permission on all tables created by tom and the tables to be created, perform the following operations:
- Assign the same schema permissions under user tom to jerry.
1
GRANT USAGE ON SCHEMA tom TO jerry;
- Grant the select permission on the table created by user tom to jerry.
1
GRANT SELECT ON ALL TABLES IN SCHEMA tom TO jerry;
- Grant select permission on tables created by user tom in the same schema to jerry.
1
ALTER DEFAULT PRIVILEGES FOR USER tom IN SCHEMA tom GRANT SELECT ON TABLES TO jerry;
- Assign the same schema permissions under user tom to jerry.
Parent topic: Account/Permission/Password
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot