Thanks Andrew for the reply.
Based on the answer, Is there a way to provide read access on all tables(
*created by any user* ) to a Read Only user?
-
--
Thanks,
Rajan.
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html
Andrew,
Another question, If the user student is not the owner of the
Schema(additional) and has only USAGE / no privileges, How come it is able
to modify permissions at schema level?
-
--
Thanks,
Rajan.
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html
> "rajan" == rajan writes:
rajan> Andrew,
rajan> Another question, If the user student is not the owner of the
rajan> Schema(additional) and has only USAGE / no privileges, How come
rajan> it is able to modify permissions at schema level?
Because it's not modifying anything that affect
THanks for the response, Andrew.
-
--
Thanks,
Rajan.
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html
> "rajan" == rajan writes:
rajan> --with the student user have no privilege how ALTER DEFAULT PRIVILEGES
rajan> works
rajan> *learning=> ALTER DEFAULT PRIVILEGES IN SCHEMA additional GRANT INSERT
ON
rajan> TABLES TO student;
This ALTER only affects the default privileges for tables
