Re: [PATCH] DefaultACLs
От | Jan Urbański |
---|---|
Тема | Re: [PATCH] DefaultACLs |
Дата | |
Msg-id | 4ABB5EBE.6090608@wulczer.org обсуждение исходный текст |
Ответ на | Re: [PATCH] DefaultACLs (Petr Jelinek <pjmodos@pjmodos.net>) |
Ответы |
Re: [PATCH] DefaultACLs
|
Список | pgsql-hackers |
OK, the previous problem went away, but I can still do something like that: postgres=# create role test; CREATE ROLE postgres=# create role test2; CREATE ROLE postgres=# create database db; CREATE DATABASE postgres=# \c db psql (8.5devel) You are now connected to database "db". db=# alter default privileges for role test2 grant insert on table to test; ALTER DEFAULT PRIVILEGES db=# \c postgres psql (8.5devel) You are now connected to database "postgres". postgres=# drop role test2; DROP ROLE postgres=# \c db psql (8.5devel) You are now connected to database "db". db=# select * from pg_default_acls ;defaclrole | defaclnamespace | defaclobjtype | defacllist ------------+-----------------+---------------+-------------------------------------- 16385 | 0 | r | {16385=arwdDxt/16385,test=a/wulczer} (1 row) db=# Dependencies suck, I know.. Jan
В списке pgsql-hackers по дате отправления: