grants on tables vs views

william giannelli

grants on tables vs views

If a user has select authority on a base table do they automatically have select authority on that table's view?

Or are the view's authority completely separate?

thanks

Bill

Walter Janißen

AW: grants on tables vs views
(in response to william giannelli)
No, I think that is one reason for using views. But if a user has select-privilege on a table, he can create his own views on that table.

Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996

Von: william giannelli <[login to unmask email]>
Gesendet: Samstag, 31. August 2019 12:09
An: [login to unmask email]
Betreff: [EXTERN] [DB2-L] - grants on tables vs views


If a user has select authority on a base table do they automatically have select authority on that table's view?

Or are the view's authority completely separate?

thanks

Bill

-----End Original Message-----
Attachments

  • image001.png (2.6k)