RE: Authority to Mapics Files from PC programs

["hrishikesh kotwal" <hdkotwal@xxxxxxxxxxx>]

   Hi All:

    

   Thanks a million for your suggestions on this issue. I am planning to
   use authorization lists to secure Mapics files. Unfortunately, I cannot
   have multiple authorization lists for a file. But that is something else I
   may need to get around....

    

   thanks again....  

   Regards,
    
   Hrishikesh Kotwal
    
   >From: lisa.thomas@xxxxxxxxxxx
   >Reply-To: MAPICS ERP System Discussion <MAPICS-L@xxxxxxxxxxxx>
   >To: mapics-l@xxxxxxxxxxxx
   >Subject: RE: Authority to Mapics Files from PC programs
   >Date: Fri, 6 Jun 2003 12:39:17 -0500
   >
   >You also may want to look into writing some stored procedures. We have
   done
   >that because even though we may want someone to have access to the item
   >number and description, we do not want them to have access to price and
   >cost.
   >
   >Another way to do this is create a logical view over the file restricting
   >the fields to what they can see. We did not choose this route because we
   >actually wanted to update Mapics offline load files. Putting forth the
   >extra effort was necessary.
   >
   >-----Original Message-----
   >From: hrishikesh kotwal [mailto:hdkotwal@xxxxxxxxxxx]
   >Sent: Friday, June 06, 2003 10:10 AM
   >To: MAPICS-L@xxxxxxxxxxxx
   >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.
   >_______________________________________________
   >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.
   >

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

   ICICI's NRI services. They make life easy. Find out more