Re: Create Table Security -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Hey Vern,

I had the same thought and group AMPGMR already had *ALL authority to user 
profile MARK.  We added Security Officer to AMPGMR as shown below and it 
still doesn't work.  I also read the authority paragraphs in the sql 
reference before posting, but I got baffled quick...

Any other ideas?

User profile . . . . . . . . . . . . . . . :   AMPGMR 
 
User class . . . . . . . . . . . . . . . . :   *SECOFR 
Special authority  . . . . . . . . . . . . :   *JOBCTL 
                                               *SAVSYS 
                                               *SECADM 
                                               *SERVICE 
                                               *SPLCTL 


Object . . . . . . . :   MARK            Owner  . . . . . . . :   AMPGMR 
  Library  . . . . . :     QSYS          Primary group  . . . :   *NONE 
Object type  . . . . :   *LIB            ASP device . . . . . :   *SYSBAS
 
Object secured by authorization list  . . . . . . . . . . . . :   *NONE 

                         Object 
User        Group       Authority 
*PUBLIC                 *ALL 
*GROUP      AMPGMR      *ALL 


Object . . . . . . . :   MARK            Owner  . . . . . . . :   MARK 
  Library  . . . . . :     QSYS          Primary group  . . . :   *NONE 
Object type  . . . . :   *USRPRF         ASP device . . . . . :   *SYSBAS

                         Object 
User        Group       Authority 
*PUBLIC                 *EXCLUDE 
MARK                    *ALL 
*GROUP      AMPGMR      *ALL

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.