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

Filed under:
|
|

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

Related posts about permissions

Related posts about ibm