Re: Re: security ??? anyone ???

Jeff,

Yes you can secure the two files GELMAS and TEMGEN, but you will need to use 
AS/400 security for the IT level.  It will require a lot of maintenance to 
ensure the files are secured, but it will provide the security you are looking 
for.

When your users are set up on the AS/400 do you give them *ALLOBJ authority?  
Hopefully not.  That means they can query any file on your AS/400 without 
restrictions.  My memory is failing me a little on how to set up the security 
on files on the AS/400 and my notes are at home.  (Currently working on a Unix 
box.)  Once you have the security required on the files, you will need to grant 
authority to the files your users need to write queries on.  The IT developers 
can be given the level under *ALLOBJ with the exception of only a few members 
which would need the higher level of security.  

The only problem with providing this level of security is the maintenance as 
someone with *ALLOBJ authority has to be the one to grant authority to the 
files when users need to write queries.  But it would allow you to set up a 
formal procedure that has their supervisor approve their request for access to 
a particular file(s).  It would also keep your shop employees from getting into 
areas they shouldn't etc.  It would also solve the problem with the board.  

I can give you more explicit instructions once I get home tonight if you need 
them.  My notes have the details and it would be a solution much better than 
"trusting" the employees.  With all the changes going on in the world companies 
really do need to reconsider how they have security set up on their AS/400 
files as it is very easy to copy or write a query that could be sold to your 
competitors.  

Good Luck and let me know if you want those step by step instructions.

Paola Groeber
MAPICS Consultant
770-591-1497 (home after 4:30pm EST)
770-490-3297 (cell)
 

> 
> From: "Jeff Snyder" <jeffreygsnyder@xxxxxxxxxxx>
> Date: 2003/03/21 Fri AM 07:55:21 EST
> To: mapics-l@xxxxxxxxxxxx
> Subject: Re: security  ???   anyone ???
> 
> 
> 
> 
> 
> 
> 
> 
> From: "Jeff Snyder" <jeffreygsnyder@xxxxxxxxxxx>
> Reply-To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
> To: mapics-l@xxxxxxxxxxxx
> Subject: security
> Date: Thu, 20 Mar 2003 16:47:12 -0500
> 
> hey group,
> 
>   I am working with a sm privately held co, that has decide to put the G/L 
> pkg on the AS400,mapics XA rel 6.0.
> 
>   We can secure thru mapics CAS. but was looking for ideas about securing 
> the I.T. Staff... with regular users i can eliminate the cmd line , etc... 
> but the board, is asking about the I.T. staff, particulary GELMAS, and 
> TEMGEN.
> 
> any thoughts would be appreciated.
> 
> thanks
> 
> Jeff Snyder,  CPIM
> Mapics consultant
> 
> 
> 
> 
> 
> 
> _________________________________________________________________
> The new MSN 8: smart spam protection and 2 months FREE*  
> http://join.msn.com/?page=features/junkmail
> 
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> To post a message email: MAPICS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> or email: MAPICS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/mapics-l.
> 
> 
> 
> _________________________________________________________________
> The new MSN 8: smart spam protection and 2 months FREE*  
> http://join.msn.com/?page=features/junkmail
> 
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> To post a message email: MAPICS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> or email: MAPICS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/mapics-l.
> 
>