GRANTS table question

[becky]

Hi all,

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)

[scutter]

The *s mean it was granted with GRANT OPTION.

[becky]

Thank you!