You are here:
- Home
- Computing/Technology
- Systems Management (Computing & Software)
- AS400 Mid Range
- Limit User Profile to Read only
AS400 Mid Range/Limit User Profile to Read only
Advertisement
Question
I have been asked to create a generic user profile for conversion of data to new warehousing system. This user needs only to read and should not be able to update or write to the AS400 database. Can I do this in the User set up? Thanks in advance for your time!
One way is to use the following commands to first revoke all authority for the user, then grant them read-only access to all files:
RVKOBJAUT OBJ(*ALL/*ALL) OBJTYPE(*FILE) USER(user ID) AUT(*ALL)
GRTOBJAUT OBJ(*ALL/*ALL) OBJTYPE(*FILE) USER(user ID) AUT(*READ)
- Laird
- Add to this Answer
- Ask a Question
Questioner's Rating
| Rating(1-10) | Knowledgeability = 10 | Clarity of Response = 10 | Politeness = 10 |
| Comment | No Comment | ||
Related Articles
- Linux Newbie Administrator Guide - 4.2 Users, passwords, file permissions, and security
- GNU/Linux Command-Line Tools Summary - File Permissions
- setfsuid - Linux Command - Unix Command
- Linux System Administrator's Guide - Shell startup
- How do I change my eBay user ID? - eBay - Frequently Asked Questions about eBay
AS400 Mid Range
Answers by Expert:
Concise Systems/Laird Scranton
Expertise
General AS/400, RPG/400, SDA and CL programming questions. AS/400 performance tuning.
Experience
Past/Present clients
CB Sportswear
Coca-Cola of New York
Encore Paper Company
Golub Corporation
HBO Home Video
Imperial Pools
Kaiser Permanente of NE New York
Mallinckrodt Medical
Marigold Foods
Manpower & Associates
National Datacomputers
New York State Easter Seals Society
New York State Food Merchants Association
Pepsi-Cola Allied Bottlers
Petricca Construction
Taconic Telephone Corporation
TOMRA Recycling
Unistress Corporation
©2012 About.com, a part of The New York Times Company. All rights reserved.