Query400 authorizations
We have used a generic user ID for our support persons to sign on to a data center. Due to audit requirements we were forced to elimiate the Generic User. Many queries were created over the years for customers and were saved with *CHANGE auhority instead of *ALL. Now that the generic user is no [...]

Answer Question   |  March 31, 2012  1:18 PM
AS/400 Authorization List, AS/400 Query, AS/400 Query Security, Query/400

AS/400 library authorization
How can a person without *ALLOBJ authority access list of libaray ?

Answer Question   |  March 31, 2012  1:33 PM
*ALLOBJ, AS/400 Authorization List, AS/400 Library

AS/400 Authorization Lists
I created a AUTL with only Read access to certain files.  When my user ran an SQL statement against one of the files in the AUTL that he is a member of it said that he did not have authority to the file.  Why would this not work?

Answer Question   |  June 20, 2011  4:47 PM
AS/400, AS/400 Authorization List, AS/400 database, AUTL

created a test profile with only *JOBCTL authority; unable to type WRKJOBSCDE
Hi all, I created a test profile with only *JOBCTL authority. I was unable to type command WRKJOBSCDE & ADDJOBSCDE, but I was able to CHGJOBSCDE, DELJOBSCDE & HLDJOBSCDE. Wanted to know what did I set wrongly, please help, thanks. User Profile : TEST User class : *USER Special authority : *JOBCTL Group profile : [...]

Answer Question   |  September 2, 2010  3:53 AM
AS/400, AS/400 Authorization List, iSeries, WRKJOBSCDE

Changing User Authority/Securing System
Is there an easy way to change user authority to read on only on an open AS400 system that is menu driven? The ability to change data, add, update etc. is coded within the programs – in other words function key driven.

Answer Question   |  July 14, 2010  1:20 PM
AS/400 Authorization List, AS/400 Permissions, AS/400 Security Data, AS/400 user permissions

AUTHID in DB2
I want to define AUTHID while create stored procedure in DB2/AS400. This can be done in oracle as CREATE OR REPLACE PROCEDURE PRC AUTHID DEFINER / CURRENT_USER can this also be done in iSeries AS/400 DB2?  

Answer Question   |  February 17, 2010  10:10 AM
AS/400 Authorization List, DB2, DB2 stored procedures

Authority lists
Hi, plz give me the step by step process of creation of an Authority list and maintaining( i mean how to use) it… thanks Ram

Answer Question   |  November 29, 2009  10:43 AM
AS/400 administration, AS/400 Authorization List

AS/400 Authorization List
Is there is any way to secure an object via more that one authorization list? If it is, then what is the use of adding more than one autl to the single object?

Answer Question   |  September 22, 2009  8:38 AM
AS/400 Authorization List

Authorization List in AS/400
What are the drawbacks of Authorization list in AS400?

Answer Question   |  September 8, 2009  5:56 AM
AS/400 administration, AS/400 Authorization List