Skip to main content
Question

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

  • September 15, 2020
  • 1 reply
  • 3 views

HyeontaeJu
Forum|alt.badge.img+2

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.)

1 reply

mosheg
Forum|alt.badge.img+2
  • Participating Frequently
  • September 15, 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