Answers for "give read access to table in postgres"

grant read only privileges postgres user

grant connect on database "mydatabase" to "user";
GRANT USAGE ON SCHEMA public TO "user";
GRANT SELECT ON ALL TABLES IN SCHEMA "public" TO "user";
ALTER DEFAULT PRIVILEGES IN SCHEMA "public"
   GRANT SELECT ON TABLES TO "user";

Posted by: Guest on November-12-2020

Code answers related to "give read access to table in postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "give read access to table in postgres"

Code answers related to "give read access to table in postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "give read access to table in postgres"

Code answers related to "give read access to table in postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us