- publishing free software manuals
PostgreSQL Reference Manual - Volume 2 - Programming Guide
by The PostgreSQL Global Development Group
Paperback (6"x9"), 408 pages
ISBN 0954612035
RRP £19.95 ($34.95)

Sales of this book support the PostgreSQL project! Get a printed copy>>>

4.5 applicable_roles

The view applicable_roles identifies all roles whose privileges the current user can use. This means there is some chain of role grants from the current user to the role in question. The current user itself is also an applicable role. The set of applicable roles is generally used for permission checking.

4-3: applicable_roles Columns
Name Data Type Description
grantee sql_identifier Name of the role to which this role membership was granted (may be the current user, or a different role in case of nested role memberships)
role_name sql_identifier Name of a role
is_grantable character_data YES if the grantee has the admin option on the role, NO if not
ISBN 0954612035PostgreSQL Reference Manual - Volume 2 - Programming GuideSee the print edition