permissions on databases vs. permissions on tables

From: Jim Mercer <jim(at)reptiles(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: permissions on databases vs. permissions on tables
Date: 2000-11-06 19:45:39
Message-ID: 20001106144538.E16128@reptiles.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


ok, so i know how to use GRANT/REVOKE to assign permission levels on tables.

however, it eludes me on how to do it on a database level.

i poked about in the manuals and nothing jumped out and said "here's how
you do it".

for example, i have a database called "samples".

in "samples", i have various tables which have been configured using
"GRANT/REVOKE" to allow/disallow various activities by users.

however, any user can create new tables.

how do i stop/restrict who can add tables (and/or indexes) ?

--
[ Jim Mercer jim(at)reptiles(dot)org +1 416 410-5633 ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]

Responses

Browse pgsql-general by date

  From Date Subject
Next Message joe 2000-11-06 19:55:50 Re: Synchronizing Data?
Previous Message Dmitriy Agafonov 2000-11-06 19:43:17 cursor name : uniqueness scope