Postgres Pro
Downloads
Home   >   mailing lists

How do I revoke CREATE TABLE and other privileges? - Mailing list pgsql-general

From Karen Hill
Subject How do I revoke CREATE TABLE and other privileges?
Date
Msg-id 1152134839.499810.161890@b68g2000cwa.googlegroups.com
Whole thread Raw
Responses Re: How do I revoke CREATE TABLE and other privileges?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view 
I would like for one role to be able to login, and execute a couple of
functions and nothing else.  I've tried to revoke access to CREATE on
the database, schema, and tablespace but when I tested it, the user was
still allowed to create tables.

regards,

pgsql-general by date:

Previous
From: Wayne Conrad
Date:
Subject: Re: Null and Void() - Or, Abandon All Hope Ye Who allow
Next
From: Bjørn T Johansen
Date:
Subject: Re: Help making a plpgsql function?