buy tb500

postgres – Create user and grant permission access

CREATE USER username WITH PASSWORD 'your_password';
GRANT USAGE ON SCHEMA schema_name TO username;
GRANT SELECT ON ALL TABLES IN SCHEMA schema_name TO username;

This entry was posted on Sunday, June 26th, 2022 at 11:13 am and is filed under DataBase. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply