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.