Skip to main content
Question

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

  • Sep 15, 2020 9:58 AM UTC
  • 1 reply
  • 7 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
  • Sep 15, 2020 12:27 PM UTC

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