Justin,
If you are discussing a true index, you are absolutely correct, however if it is the "Logical File" Joe referred to (meaning the hybrid index/view object) then I believe the user would need access to the "Logical".
Joe: If you just create an index your problem would most likely go away since the optimizer should pick that up an use it in the query (Visual Explain time). If not let Visual Explain tell you want index it wants. Then the users only needs access to the actual table.
--
Jim Oberholtzer
Agile Technology Architects
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Justin Taylor
Sent: Friday, May 1, 2020 9:02 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: Authority required for SQL
My understanding is no, but I can't cite a reference. I create all of my indexes as *PUBLIC *EXCLUDE with no private authorities.
HTH
-----Original Message-----
From: Joe Pluta [mailto:joepluta@xxxxxxxxxxxxxxxxx]
Sent: Friday, May 01, 2020 8:00 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Authority required for SQL
Say I have two objects: a physical file with no key and a logical over that physical. Both are created using DDS. I want to access the data in the file from ODBC using a common ODBC profile, so my natural inclination is to grant *USE access to the ODBC user profile to the physical file. Here's the question: when my ODBC goes to get data in the order of the logical, does it need to have *USE rights for the logical in order for the SQL engine to take advantage of it?
Basically I'm just trying to decide whether my ODBC profile needs access to my logicals. I'd like to set up a standard as I convert my system from private authorities to AUTLs.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
