The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Is it possible inherit schema's privileges to sequence??
HyeontaeJu
Vertica Customer ✭
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.)
0
Answers
Inherited privileges can be enabled at the following levels.
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.
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