By Kainat Naz
My postgres databse keeps the value postgres for database name even when I create new db and new user. It seems that no matter what I do, I cannot alter it.facing the error I want to use my database name and user when i change the database name to “postgres” and username into “doadmin” application connecting to the database else showing this error on change the name of my db and user
apps@feedback-app-7-jx2mf:~$ rails db:migrate
rails aborted!
ActiveRecord::StatementInvalid: PG:: Insufficient Privilege: ERROR: permission denied for table schema_migrations /workspace/bin/rails:5:in `<main>'
Caused by:
PG:: InsufficientPrivilege: ERROR: permission denied for table schema_migrations
/workspace/bin/rails:5:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace) apps@feedback-app-7-jx2mf:~$
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Accepted Answer
This help me in resolving this error
GRANT ALL PRIVILEGES ON DATABASE your_database to your_database_user; ALTER DATABASE your_database OWNER TO your_database_user;
Hi there,
Once you’ve added your new database user, you would also need to add the required privileges so that the user would have access to your database in question.
With the DigitalOcean Managed database clusters, you can do that by following the steps from the documentation here:
https://docs.digitalocean.com/products/databases/postgresql/how-to/modify-user-privileges/
psql "postgresql://doadmin:your_password@cluster-do-user-1234567-0.db.ondigitalocean.com:25060/defaultdb?sslmode=require"
\connect example_database
your_user
with your user name:GRANT ALL PRIVILEGES ON DATABASE your_database TO your_user;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO your_user;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO your_user;
Let me know how it goes after that!
Best,
Bobby
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.