Is it possible inherit schema's privileges to sequence??

HyeontaeJu

Is it possible inherit schema's privileges to sequence??
If is it can't, why is sequence can't inherit schema's privileges?
(It is very inconvenient to assign permissions for each user to the sequence.)

Hibiki

Inherited privileges can be enabled at the following levels.

• Database
• Schema
• Tables and views

https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/AdministratorsGuide/DBUsersAndPrivileges/Privileges/InheritedPrivilegesOverview.htm

This is the current product specification. Please raise an enhancement request with the information about your business background if possible.

mosheg

In addition, try to use Database Roles to avoid the inconvenient to assign permissions for each user separately.
See: https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/AdministratorsGuide/DBUsersAndPrivileges/Roles/AboutDatabaseRoles.htm