RE: Restricting access to data only from certain views

Also, consider an inline table function.

-Matt

From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Friday, September 24, 2021 1:17 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: Restricting access to data only from certain views

I think I'm going to have to use a stored procedure which adopts the appropriate authority. Rob Berendt -- IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 7310 Innovation
External (rob@xxxxxxxxx<mailto:rob@xxxxxxxxx>)

Report This Email<https://shared.outlook.inky.com/report?id=d2luY29mb29kcy9tYXR0LnR5bGVyQHdpbmNvZm9vZHMuY29tLzY5YzAxOWU4ZmYyMGQyNTNiMmE5OTQwMTJjZjAzZmMzLzE2MzI1MTEwMjUuMjg=#key=071fd3974ddf8b310506634e9283a09e>


I think I'm going to have to use a stored procedure which adopts the appropriate authority.



Rob Berendt

--

IBM Certified System Administrator - IBM i 6.1

Group Dekko

Dept 1600

Mail to: 7310 Innovation Blvd, Suite 104

Ft. Wayne, IN 46818

Ship to: 7310 Innovation Blvd, Dock 9C

Ft. Wayne, IN 46818

https://urldefense.com/v3/__http://www.dekko.com__;!!O6xM9Yim9Yk!qe6ANo-vHMdDv7-P1bXleDDpwWxPnuvtdyPfcDaPZcgugixBgayAYzJWZbYfWuq7BzNR$<https://urldefense.com/v3/__http:/www.dekko.com__;!!O6xM9Yim9Yk!qe6ANo-vHMdDv7-P1bXleDDpwWxPnuvtdyPfcDaPZcgugixBgayAYzJWZbYfWuq7BzNR$>





-----Original Message-----

From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx<mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx>> On Behalf Of Rob Berendt

Sent: Friday, September 24, 2021 2:22 PM

To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>>

Subject: Restricting access to data only from certain views



Let's say you have a table called TABLEX in schema PF and a view called VIEWX in schema LF.

Can you set it up so that the person can only see the data in TABLEX by using the view VIEWX?

I do not want to use any exit points if I can avoid it. I prefer to secure the data and not play whack-a-mole trying to figure out ways to get to the data.



Rob Berendt

--

IBM Certified System Administrator - IBM i 6.1

Group Dekko

Dept 1600

Mail to: 7310 Innovation Blvd, Suite 104

Ft. Wayne, IN 46818

Ship to: 7310 Innovation Blvd, Dock 9C

Ft. Wayne, IN 46818

https://urldefense.com/v3/__http://www.dekko.com__;!!O6xM9Yim9Yk!qe6ANo-vHMdDv7-P1bXleDDpwWxPnuvtdyPfcDaPZcgugixBgayAYzJWZbYfWuq7BzNR$<https://urldefense.com/v3/__http:/www.dekko.com__;!!O6xM9Yim9Yk!qe6ANo-vHMdDv7-P1bXleDDpwWxPnuvtdyPfcDaPZcgugixBgayAYzJWZbYfWuq7BzNR$>



--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>

To subscribe, unsubscribe, or change list options,

visit: https://urldefense.com/v3/__https://lists.midrange.com/mailman/listinfo/midrange-l__;!!O6xM9Yim9Yk!qe6ANo-vHMdDv7-P1bXleDDpwWxPnuvtdyPfcDaPZcgugixBgayAYzJWZbYfWnnll_N1$<https://urldefense.com/v3/__https:/lists.midrange.com/mailman/listinfo/midrange-l__;!!O6xM9Yim9Yk!qe6ANo-vHMdDv7-P1bXleDDpwWxPnuvtdyPfcDaPZcgugixBgayAYzJWZbYfWnnll_N1$>

or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>

Before posting, please take a moment to review the archives

at https://urldefense.com/v3/__https://archive.midrange.com/midrange-l__;!!O6xM9Yim9Yk!qe6ANo-vHMdDv7-P1bXleDDpwWxPnuvtdyPfcDaPZcgugixBgayAYzJWZbYfWvzzqdvp$<https://urldefense.com/v3/__https:/archive.midrange.com/midrange-l__;!!O6xM9Yim9Yk!qe6ANo-vHMdDv7-P1bXleDDpwWxPnuvtdyPfcDaPZcgugixBgayAYzJWZbYfWvzzqdvp$> .



Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.



Help support midrange.com by shopping at amazon.com with our affiliate link: https://urldefense.com/v3/__https://amazon.midrange.com__;!!O6xM9Yim9Yk!qe6ANo-vHMdDv7-P1bXleDDpwWxPnuvtdyPfcDaPZcgugixBgayAYzJWZbYfWsWSWFAe$<https://urldefense.com/v3/__https:/amazon.midrange.com__;!!O6xM9Yim9Yk!qe6ANo-vHMdDv7-P1bXleDDpwWxPnuvtdyPfcDaPZcgugixBgayAYzJWZbYfWsWSWFAe$>

--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>

To subscribe, unsubscribe, or change list options,

visit: https://urldefense.com/v3/__https://lists.midrange.com/mailman/listinfo/midrange-l__;!!O6xM9Yim9Yk!qe6ANo-vHMdDv7-P1bXleDDpwWxPnuvtdyPfcDaPZcgugixBgayAYzJWZbYfWnnll_N1$<https://urldefense.com/v3/__https:/lists.midrange.com/mailman/listinfo/midrange-l__;!!O6xM9Yim9Yk!qe6ANo-vHMdDv7-P1bXleDDpwWxPnuvtdyPfcDaPZcgugixBgayAYzJWZbYfWnnll_N1$>

or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>

Before posting, please take a moment to review the archives

at https://urldefense.com/v3/__https://archive.midrange.com/midrange-l__;!!O6xM9Yim9Yk!qe6ANo-vHMdDv7-P1bXleDDpwWxPnuvtdyPfcDaPZcgugixBgayAYzJWZbYfWvzzqdvp$<https://urldefense.com/v3/__https:/archive.midrange.com/midrange-l__;!!O6xM9Yim9Yk!qe6ANo-vHMdDv7-P1bXleDDpwWxPnuvtdyPfcDaPZcgugixBgayAYzJWZbYfWvzzqdvp$> .



Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.



Help support midrange.com by shopping at amazon.com with our affiliate link: https://urldefense.com/v3/__https://amazon.midrange.com__;!!O6xM9Yim9Yk!qe6ANo-vHMdDv7-P1bXleDDpwWxPnuvtdyPfcDaPZcgugixBgayAYzJWZbYfWsWSWFAe$<https://urldefense.com/v3/__https:/amazon.midrange.com__;!!O6xM9Yim9Yk!qe6ANo-vHMdDv7-P1bXleDDpwWxPnuvtdyPfcDaPZcgugixBgayAYzJWZbYfWsWSWFAe$>