Revoking CREATE TABLE

Поиск
Список
Период
Сортировка
От Tony Webb
Тема Revoking CREATE TABLE
Дата
Msg-id 36C87DE3A8179546A8B2D00CC609EBB0055E65@exchsrv4.internal.sanger.ac.uk
обсуждение исходный текст
Ответы Re: Revoking CREATE TABLE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bryan Murphy
Дата:
Сообщение: Re: Warm Standby Setup Documentation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Revoking CREATE TABLE