So you are wanting to list only SYSCATALOG rows where the user has authority to know of the table that the row references. Right?
Somehow you need to obtain a table of objects that the current user has access to, either by specific UserID, Authorization list or by User Profile Authorities and membership in a Group Profiles and such.
Then join this list to the SYSCATALOG on object and you will have your list of objects that the user has actually got permission to see.
It isn't pretty. If someone has a better solution, I'd be interested in hearing it.
Steve Needles
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Justin Taylor
Sent: Monday, July 24, 2017 5:11 PM
To: MIDRANGE-L (midrange-l@xxxxxxxxxxxx) <midrange-l@xxxxxxxxxxxx>
Subject: Query client possible to limit tables shown
This is a follow-up to my "Read-only SYSCATALOGS OK?" (
https://archive.midrange.com/midrange-l/201707/msg00374.html).
The client is showing every table in SYSCATALOGS, regardless of whether the user is authorized to view it. This is causing confusion for the users, and frustration for the users and the admin (me). Is there a good way to fix this? We're using the IBMi data provider (IBM I Access ODBC driver). I've tried multiple clients and they all behave the same.
Thanks
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
CONFIDENTIAL: The information contained in this email communication is confidential information intended only for the use of the addressee. Unauthorized use, disclosure or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by return email and destroy all copies of this communication, including all attachments.
midrange.com
