Restricting Groups / Users
Restricting Groups / Users
От:
Hadley Willan <hadley.willan@deeperdesign.co.nz>
Дата:
Hi,
I'm running pgsql 7.4.1 and I was wondering if it is possible to restrict users from creating tables.
Basically I want to give some users READ-ONLY access to a majority of the system.
Thanks
I'm running pgsql 7.4.1 and I was wondering if it is possible to restrict users from creating tables.
Basically I want to give some users READ-ONLY access to a majority of the system.
Thanks
--
|
Re: Restricting Groups / Users
От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
Hadley Willan wrote: > Hi, > I'm running pgsql 7.4.1 and I was wondering if it is possible to > restrict users from creating tables. > > Basically I want to give some users READ-ONLY access to a majority of > the system. Yes, you can control permissions on the public schema and the other schemas. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Re: Restricting Groups / Users
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Bruce Momjian writes: > Hadley Willan wrote: >> I'm running pgsql 7.4.1 and I was wondering if it is possible to >> restrict users from creating tables. > Yes, you can control permissions on the public schema and the other > schemas. Specifically, revoke their CREATE rights on public (as well as any other schemas you've created) and revoke their CREATE rights on the database so they can't create any new schemas to create tables in. If you are feeling draconian enough to want to prohibit creation of temp tables as well as regular tables, then also remove TEMP rights at the database level. I'm dubious about the usefulness of this though. regards, tom lane