IBM System i Permissions on Database views
Posted
by
Big EMPin
on Server Fault
See other posts from Server Fault
or by Big EMPin
Published on 2013-11-05T14:39:32Z
Indexed on
2013/11/05
15:57 UTC
Read the original article
Hit count: 338
We have an IBM System i running IBM i OS v6r1. On this system, I have created some database views. What I want to do is give a particular user group access to ONLY these views and nothing else within the library in which the views reside. Is this possible? I had a user group that had read only permissions to all tables and views in the library in which my views are located, and access works when the user is under this usergroup. I tried copying the user group, and then assigning permissions to only include the views I have created, and access is denied. Does a user or usergroup also have to have permissions on the table from which the view originates in order to access the view?
© Server Fault or respective owner