debugsqlMinor
Even after permissions are updated, I still get the error permission denied for relation users
Viewed 0 times
afterpermissionstheerrorstillarepermissiondeniedgetfor
Problem
I'm getting the error
In the Grants tab of DBVisualizer I can see that the my_user user has the privileges
ERROR: permission denied for relation users and have tried to update privileges using both grant all privileges on all tables in schema ops to my_userGRANT ALL PRIVILEGES ON TABLE the_table TO my_userIn the Grants tab of DBVisualizer I can see that the my_user user has the privileges
DELETE, INSERT, SELECT, TRUNCATE, and UPDATE. IS_GRANTABLE is set to NO for all of these. Yet I still get this error. What is there left to do.Solution
In addition to privileges on the
Or at least:
TABLE, a role needs privileges for the SCHEMA and the DATABASE. The most likely candidate is the schema. If so, this additional GRANT would be the fix:GRANT ALL ON SCHEMA my_schema TO my_user;Or at least:
GRANT USAGE ON SCHEMA my_schema TO my_user;Code Snippets
GRANT ALL ON SCHEMA my_schema TO my_user;GRANT USAGE ON SCHEMA my_schema TO my_user;Context
StackExchange Database Administrators Q#56028, answer score: 8
Revisions (0)
No revisions yet.