database rights?

Поиск
Список
Период
Сортировка
От Engard Ferenc
Тема database rights?
Дата
Msg-id Pine.LNX.4.02.10002240858270.224-100000@domesticus.sote.hu
обсуждение исходный текст
Ответы Re: [SQL] database rights?
Список 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 по дате отправления:

Предыдущее
От: Rolf Staege
Дата:
Сообщение: create a database
Следующее
От: "James Macken"
Дата:
Сообщение: PostgreSQL and PHP