permissions on databases - Mailing list pgsql-general

From Tressens Lionel
Subject permissions on databases
Date
Msg-id Pine.LNX.4.10.10102061758560.1218-100000@jaures.etud.insa-tlse.fr
Whole thread Raw
Responses Re: permissions on databases  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
List pgsql-general
Hi all,

I am the super user of my DBMS and if create a database for a simple user,
I do :

=> create database formyuser;

But If this user connects to the database and tries to create a table, he
has no rights. I must (the super user) create the table for him and then
give him all the permissions with GRANT.

So my question is : How can I create a database for a simple user (ie not
super user) and give him all the rigths to create and drop tables in it ?

Thanks in advance for your answer

Lionel


pgsql-general by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: PostreSQL SQL for MySQL SQL
Next
From: "Brett W. McCoy"
Date:
Subject: Re: permissions on databases