Skip to main content
Question

Why is the error occured?? When I use ALTER VIEW view1 INCLUDE SCHEMA PRIVILEGES;

  • September 15, 2020
  • 3 replies
  • 8 views

HyeontaeJu
Forum|alt.badge.img+2

Why is the message occured?? When I use ALTER VIEW view1 INCLUDE SCHEMA PRIVILEGES;
"View "view" is already set to inherit privileges"
I wanna that view inherit schema's grants list and I expect that the grantee list is inherited to view

3 replies

HyeontaeJu
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • September 15, 2020

if the view inherit privilege of schema ,why is the view doesn't have grantee in grants table?


HyeontaeJu
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • September 15, 2020

@Hibiki
I have a question. If the view inherit the schema's privilege.
Why is the view don't have grantee list in grants table??


HyeontaeJu
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • September 15, 2020

@Hibiki
Oh I see,,
By the way, 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.)