Postgres db help
Hi , I recently migrated EC2 postgres to RDS and I'm facing the problem with one table that has a sequence . When trying to insert Im getting permissions error . I granted all the permissions already to the owner of the schema and the user that tries the insert operation but still facing the same error . Please advise how can I solve it
attached screenshots 
- Newest
- Most votes
- Most comments
By looking to the error, it seems usage grant on schema UCM is missing for the user trying to insert data into the table.
Could you try to give usage grant "grant usage on schema ucm to <user>;"
answered 3 years ago
I have addressed your concerns as follows-
Please allow me to mention that this error arises when you do not provide the access to the schema you are trying to make modification/ selection from.
I would recommend you try to login from your master user and grant the particular user access on the schema 'ucm'.
Syntax to do the same:
"grant usage on schema ucm to <user>;
You can also kindly refer to document attached below for user and role grants in RDS Postgres [+]https://aws.amazon.com/blogs/database/managing-postgresql-users-and-roles/
I sincerely hope this helps!
answered 3 years ago
Relevant content
asked 3 years ago
