Answers for "postgres how to grant access to user after db creation"

psql set access privileges

REVOKE ALL ON DATABASE example_database FROM example_user;
GRANT CONNECT ON DATABASE example_database TO example_user;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO example_user;

Posted by: Guest on April-27-2020

Source

Code answers related to "postgres how to grant access to user after db creation"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

Answers for "postgres how to grant access to user after db creation"

Code answers related to "postgres how to grant access to user after db creation"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "postgres how to grant access to user after db creation"

Code answers related to "postgres how to grant access to user after db creation"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us