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

HyeontaeJu · September 2020

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 · September 2020

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 · September 2020

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

We're Moving!

Create My New Community Account Now

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

Answers

Leave a Comment