Not Allowing Users to Create Tables

From: "Neil Cameron" <n(dot)cameron(at)blueice(dot)co(dot)uk>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Not Allowing Users to Create Tables
Date: 2000-01-12 17:19:49
Message-ID: 000701bf5d21$40d889a0$03c6c6c6@leckhampton
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi

I want to arrange things such that a user must be expressly granted the privilage to create tables. Something like

"GRANT TABLES ON USER". Can this be done?

I seem to find that when I create a user they automatically have the rights to create tables.

Neil @ blue ice

Browse pgsql-sql by date

  From Date Subject
Next Message Greg Youngblood 2000-01-12 17:52:51 Rules, triggers, ??? - What is the best way to enforce data-valid ation tests?
Previous Message Thomas Lockhart 2000-01-12 16:26:05 Re: [HACKERS] Re: [SQL] createdb -D xxxx not working