<div>
Probably not, because they can still use objects that have *PUBLIC authority assigned to them.<br />
<br />
To make the account as restricted as possible, make sure the Group Profile is *NONE, and set the Initial Program to *NONE. That stops the user from logging in, but still lets them connect via ODBC.
</div>


<div>
Thanks Thomas, &nbsp;I have those parms locked down. &nbsp;This is our first real foray into opening up our Iseries to external query so we're a little jittery about it here.<br />
<br />
The file I do want him to access has *PUBLIC authority set to *EXCLUDE and my administrator ID set to *ALL. &nbsp;Because of this, do I need to create authority specifically for that user over this file to allow the ODBC connection? &nbsp;If necessary, authority would be set to *USE.
</div>


<div>
thank you both. &nbsp;Lots of food for thought. &nbsp;Splitting the points.
</div>


<div>
<div class="content wysiwyg-content">
Hi. &nbsp;I'm running OS400 V7R1 on an IBM Iseries system. &nbsp;I've created a new user with minimal access. &nbsp; &nbsp;User Class = *USER, Limit Capabilities = *YES &amp;&nbsp;Special Authority = *NONE. &nbsp; This user only needs to access a single object on my system via ODBC and I want to grant this user read only access to that object specifically. &nbsp;Can this be accomplished by granting *USE authority for that single object? &nbsp; thanks
</div>
</div>


Hi.  I'm running OS400 V7R1 on an IBM Iseries system.  I've created a new user with minimal access.    User Class = *USER, Limit Capabilities = *YES & Special Authority = *NONE.   This user only needs to access a single object on my system via ODBC and I want to grant this user read only access to that object specifically.  Can this be accomplished by granting *USE authority for that single object?   thanks

Iseries Object Security

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.

IBM System i

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.