Revoking CREATE TABLE
| От | Tony Webb |
|---|---|
| Тема | Revoking CREATE TABLE |
| Дата | |
| Msg-id | 36C87DE3A8179546A8B2D00CC609EBB0055E65@exchsrv4.internal.sanger.ac.uk обсуждение исходный текст |
| Ответы |
Re: Revoking CREATE TABLE
|
| Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: