GRANTS table question
Posted: Wed Aug 22, 2012 3:49 pm
Hi all,
Does anyone know what the asterisks mean in the PRIVILEGES_DESCRIPTION column when I select from the GRANTS table?
Example:
Does anyone know what the asterisks mean in the PRIVILEGES_DESCRIPTION column when I select from the GRANTS table?
Example:
Code: Select all
dbadmin=> select * from grants where object_name = 'building_1';
grantor | privileges_description | object_schema | object_name | grantee
---------+-------------------------------------------------+---------------+-------------+---------
dbadmin | INSERT*, SELECT*, UPDATE*, DELETE*, REFERENCES* | vertica01 | building_1 | dbadmin
dbadmin | SELECT | vertica01 | building_1 | becky
(2 rows)