From: | "Tharmarajah, Sam" <sambavan(dot)tharmarajah(at)usask(dot)ca> |
---|---|
To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Req for some help in figuring out table create grants |
Date: | 2020-04-27 20:22:52 |
Message-ID: | YTBPR01MB25759C4DD638FF536127E863F1AF0@YTBPR01MB2575.CANPRD01.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi
I am new to postgres and I am lost in figuring out how the privilege grants are dealt with.
I have a two roles my_connect role has
GRANT CONNECT ON DATABASE mydb TO my_connect;
And my_developer with the following grants:
GRANT SELECT ON ALL TABLES IN SCHEMA PUBLIC TO my_developer;
GRANT SELECT ON ALL SEQUENCES IN SCHEMA PUBLIC TO my_developer;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA PUBLIC TO my_developer;
Now when I create a user with no privs and grant only these roles with inherit, what does allow the user to create a table in the public schema? Shouldn't these privs limit the table creation for the user?
If I want to limit the user's ability of operation to the role, that were granted, how do I accomplish that?
Any help will be much appreciated. Thanks for all your responses in advance.
Thanx,
Sam
From | Date | Subject | |
---|---|---|---|
Next Message | J T | 2020-04-27 23:03:11 | Partitions and planner |
Previous Message | Johannes Truschnigg | 2020-04-27 06:10:17 | Re: how do I turn off |