Re: Authority to Mapics Files from PC programs

[nathan.quinones@xxxxxxxxxx]

Just because a user is a MAPICS user doesn't give them "read" rights to 
MAPICS files.  The only reason MAPICS users have access to the MAPICS 
files is through application programs (RPG) that are owned by AMAPICS and 
are setup to run under the owner's authority (AMAPICS).

Normally, a MAPICS user should not have access to query or DFU a MAPICS 
file.  However, some people give AMAPICS group profile to their MAPICS 
users to allow them to query the MAPICS files.  This is dangerous since 
those users now have authority to the MAPICS files (queries or UPDDTA).

So, I don't have an easy answer, I just wanted to explain how MAPICS users 
can access the MAPICS files.

Nathan Quinones
Custom Systems Corp
973-726-0202 x213
http://www.cussys.com




"hrishikesh kotwal" <hdkotwal@xxxxxxxxxxx>
Sent by: mapics-l-bounces+nathan.quinones=cussys.com@xxxxxxxxxxxx
06/06/2003 10:09 AM
Please respond to MAPICS ERP System Discussion

 
        To:     MAPICS-L@xxxxxxxxxxxx
        cc: 
        Subject:        Authority to Mapics Files from PC programs


   Hi all:

 

   We have started developing many PC programs that access Mapics Files 
via
   ODBC & SQL. The users who use these PC programs are also Mapics Users.
   Therefore, they already have atleast 'Read' access to Popular Mapics
   files. But when the same users are trying to access the files from PC
   programs, they get the following error message:

   *** START ***

   General SQL error.

   [IBM][Client Access Express ODBC Driver [32-bit][DB2/400 SQL]SQL0551 - 
Not
   authorized to object ITEMASA in AMFLIBQ type *FILE.

   ***END***

   How to deal with this problem?

   Thanks in advance.

 

   Regards,
 
   Hrishikesh Kotwal
 

 ----------------------------------------------------------------------

   It's magic. It's a whole new world. It's the Windows XP experience.
_______________________________________________
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.