Business Team Meeting Discussion Working Concept
The HAS_ROLE function returns a Boolean value that indicates whether a role has been assigned to a user.
Example:
To create a read only user and role, do the following:
dbadmin=> CREATE ROLE read_only_role;
CREATE ROLE
dbadmin=> CREATE USER read_only;
CREATE USER
dbadmin=> GRANT read_only_role TO read_only;
GRANT ROLE
Later, I can verify that I made that grant by querying the V_CATALOG.GRANTS system table:
dbadmin=> SELECT object_name, grantee, object_type
dbadmin-> FROM grants
dbadmin-> WHERE grantee = 'read_only'
dbadmin-> AND object_type = 'ROLE';
object_name | grantee | object_type
----------------+-----------+-------------
read_only_role | read_only | ROLE
(1 row)
But it’s a lot easier to use the HAS_ROLE function:
dbadmin=> SELECT has_role('read_only', 'read_only_role');
has_role
----------
t
(1 row)
Have Fun!
About the Author
Soniya Shah
Information Developer
Currently, a first year law student with a background in science and technology. Experienced technical writer, with specializations in software documentation, big data, blog development, and website development. I build user-centered content to communicate complex and technical information more easily.
I used to work for Vertica full time for about 3 years. I still work at Vertica part time while going to law school.
Update: Soniya is now doing her law internship, and no longer working at Vertica. Good luck, Soniya!
