Oracle - ODBC- AS400 : Permissions (Select only)

gnivkor used Ask the Experts™
I have a link from oracle to an AS400,

i wish that the link could only do select statements from oracle to as400

should this be done at the oracle level by creating a user who only has select granted or is this something that is done at the ODBC or AS400 level
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Oracle Database Administrator III
This is a previously asked question, and answered under


thank you, i need to use the search feature more often

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial