Re: permissions on databases vs. permissions on tables

Dear Jim,

I've post the same question one week ago on pgsql-sql@postgresql.org but
none has answered until today.
Perhaps this is not a problem or this seems an obvious topic.

I hope that at least someone tells us how this question is silly.


Bye,          \fer

> 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.  ]