permissions on databases vs. permissions on tables - Mailing list pgsql-general

From Jim Mercer
Subject permissions on databases vs. permissions on tables
Date
Msg-id 20001106144538.E16128@reptiles.org
Whole thread Raw
Responses Re: permissions on databases vs. permissions on tables  (Ferruccio Zamuner <nonsolosoft@diff.org>)
List 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@reptiles.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.  ]

pgsql-general by date:

Previous
From: Dmitriy Agafonov
Date:
Subject: cursor name : uniqueness scope
Next
From: joe@jwebmedia.com
Date:
Subject: Re: Synchronizing Data?