Answers for "Grant read-only privilleges to the user"

SQL

0

Grant read-only privilleges to the user

GRANT CONNECT ON DATABASE wsh TO <username>;
GRANT USAGE ON SCHEMA public TO <username>;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO <username>;
GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO <username>;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO <username>;

Posted by: Guest on April-11-2022

Code answers related to "Grant read-only privilleges to the user"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#