× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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$>

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.