Re: TODO item question [pg_hba.conf]
| От | Gevik Babakhani |
|---|---|
| Тема | Re: TODO item question [pg_hba.conf] |
| Дата | |
| Msg-id | 6286.195.169.118.227.1145632910.squirrel@webmail.xs4all.nl обсуждение исходный текст |
| Ответ на | Re: TODO item question [pg_hba.conf] (Alvaro Herrera <alvherre@commandprompt.com>) |
| Ответы |
Re: TODO item question [pg_hba.conf]
Re: TODO item question [pg_hba.conf] |
| Список | pgsql-hackers |
Thank you :)
> You are missing an ACL_*_CHR symbol and updating the ACL_ALL_RIGHTS_STR
> symbol.
That is why I could not see the new permission in pg_database.
I was actually looking for that for sometime :)
I have added the ACL_*_CHR 'D' Is this okay?
> Also, you should know that changing this requires a change in
> CATALOG_VERSION_NO in catversion.h as well.
Why is this needed? Is this a functional requirement?
I have changed it to
#define CATALOG_VERSION_NO 200604211
Is this okay?
Regards,
Gevik.
gevik=# create role user1;
CREATE ROLE
gevik=# grant connection on database db2 to user1;
GRANT
gevik=# select datname,datacl from pg_catalog.pg_database; datname | datacl
-----------+------------------------------------------postgres |db1 | {=T/gevik,gevik=CTD/gevik}template1 |
{gevik=CTD/gevik}template0| {gevik=CTD/gevik}gevik | {=T/gevik,gevik=CTD/gevik}db2 |
{=T/gevik,gevik=CTD/gevik,user1=D/gevik}
(6 rows)
В списке pgsql-hackers по дате отправления: