Login module : SQL Scripts

[Former Member]

Hi,

we are using SMP 3.0 SP09 with WM 8.0

I know that the architecture necessitates read/write access to the system user configured in Agentry.ini's  sql section, to run the sql scripts in SQLBE.ini. The customer has security concerns and is asking for an alternate solution where user will have only read access.

Could you suggest a solution?

Regards,

Anurag

[bill_froelich]

The other solution would be to put the syclo tables in another schema with read/write access and have only read (and sp/funciton) executeaccess to the maximo schema.  This would require modifications of all the application scripts and admin procedures.

The user doesn't need write access to any of the Maximo tables just the syclo objects if that is an option.

--Bill

[Former Member]

The user that is used to run the login scripts is not the end user, but the user stated in the Agentry.ini.  This user needs write access to write to the Syclo tables  for the Exchange logic.