Denying CREATE TABLE capability - Mailing list pgsql-admin

From Michael Minock
Subject Denying CREATE TABLE capability
Date
Msg-id 001901c0a8a4$1e099020$a529ef82@struts.cs.umu.se
Whole thread Raw
Responses Re: Denying CREATE TABLE capability  (R D <mrk279@yahoo.com>)
List pgsql-admin
Hello all -

My users are able to connect to a main database and then create their own
databases.
However I do not want them to be able to create tables in the main database.
But in the main database, some users always create tables, which I have to
periodically go in and drop.

I have tried to deny users capability to add tables in the main database by
revoking users rights on the catalog relations.
Especially pg_class, etc... Still I have found no way to achieve the above
policy.

Does anyone know the trick to get this policy enforced?

Thanks,
Mike Minock


pgsql-admin by date:

Previous
From: Spy
Date:
Subject: Re: Use of the LIMIT clause ?
Next
From: "justin.lipshitz"
Date:
Subject: Permissions on Functions