Re: Role Attribute Bitmask Catalog Representation

Поиск

Список

Период

Сортировка

От	Adam Brightwell
Тема	Re: Role Attribute Bitmask Catalog Representation
Дата	29 ноября 2014 г. 00:20:52
Msg-id	CAKRt6CTL9Y7wvt2Ti5T6OdezX4f3gLf=HxPUx3vO7GXV0ATciQ@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Role Attribute Bitmask Catalog Representation (Stephen Frost <sfrost@snowman.net>)
Ответы	Re: Role Attribute Bitmask Catalog Representation
Список	pgsql-hackers

All,

I have attached a patch that addresses the current suggestions and recommendations:

* Add 'get_all_role_attributes' SQL function - returns a text array representation of the attributes from a value passed to it.

Example:

postgres=# SELECT rolname, get_all_role_attributes(rolattr) AS rolattr FROM pg_authid;

rolname | rolattr

----------+-----------------------------------------------------------------------------------------------

postgres | {Superuser,Inherit,"Create Role","Create DB","Catalog Update",Login,Replication,"Bypass RLS"}

(1 row)

* Refactor #define's from 'parsenodes.h' to 'acl.h'

* Added #define ROLE_ATTR_ALL to represent all currently available attributes.

* Added genbki.pl substitution for PGROLEATTRALL constant.

Please let me know what you think, all feedback is greatly appreciated.

Thanks,

Adam

В списке pgsql-hackers по дате отправления: