Hi, I would like a setup with the following: Three users – one, called OWNER, that owns the tables
and can drop, alter and change data in the tables; another called USER that can
edit data in the tables created by the owner but cannot create new tables or drop
any tables and a third user called RO which has read only access to OWNER’s
tables but cannot change any data or create new tables etc. I can grant table privileges to the USER and RO but how do I
stop these two users from creating
new tables etc? I’m creating the tables from a script so I don’t
think I can easily create a schema so am relying on the public schema. I suspect I’m missing something fundamental here :-\ All help gratefully received. Thanks Pif -- The Wellcome Trust Sanger Institute is operated by Genome Research Limited, a charity registered in England with number 1021457 and a company registered in England with number 2742969, whose registered office is 215 Euston Road, London, NW1 2BE. |