Thanks. I will do testing.
On Thu, Feb 18, 2010 at 4:29 PM, Richard Huxton <dev@xxxxxxxxxxxx> wrote:
On 18/02/10 10:54, dipti shah wrote:Sounds about right. Always test though.
Okay then I think below works:
1. Revoke permission ALL permissions from PUBLIC on schema.
REVOKE ALL ON ALL TABLES IN SCHEMA mySchema FROM PUBLIC;
2. Give store procedure for creating table with SECURITY DEFINER marked
so that all tables owner will be "postgres" user.
3. Grant SELECT permission to required group on created table.
4. Give store procedure for droping the table with SECURITY DEFINER
marked so that droping will happen in the context of "postgres" user.
I think above will not allow anyone to create and/or drop tables directly
without using store procedures.
Please let me know if I am missing anything.
--
Richard Huxton
Archonet Ltd
