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 по дате отправления: