postgresql check privileges on schema 1

postgresql check privileges on schema

GRANT SELECT ON ALL TABLES IN SCHEMA PUBLIC TO testuser2;

Here is what the above code is Doing:
1. Create a new user called testuser2
2. Create a new database called testdb2
3. Grant all privileges on testdb2 to testuser2
4. Grant SELECT privileges on all tables in the public schema to testuser2

Similar Posts