database rights? - Mailing list pgsql-sql

From Engard Ferenc
Subject database rights?
Date
Msg-id Pine.LNX.4.02.10002240858270.224-100000@domesticus.sote.hu
Whole thread Raw
Responses Re: [SQL] database rights?
List pgsql-sql
Hi all,

When I create a table, what depends that I can do it on? And, what
permissions will be create the new table with?

Ie, I have a database, and I want to access it with two users, and
one of them can create tables, but the newly created tables should be
accessed by the other user by default. And what if I want to create
tables with two users in it?

With the 'createuser' command it asks whether I want to create a new
database for the new user, and warns 'don't forget to create a
database for almafa' if I don't create. How can I do it later, or
change the owner of a database/table?

As long as I see, the grant/revoke works only for tables... Can I set
it to rows maybe...? Or should I create views for that?

Thanks:
Circum

--
Need more drivers for linux! -- http://www.libranet.com/petition.html__  @
/  \    _   _                                           Engárd Ferenc
l    | ( \ /  | | (\/)                      mailto:s-fery@kkt.sote.hu
\__/ | |   \_ \_/ I  I                    http://pons.sote.hu/~s-fery




pgsql-sql by date:

Previous
From: Rolf Staege
Date:
Subject: create a database
Next
From: "James Macken"
Date:
Subject: PostgreSQL and PHP