Example: SQL Output File (Lawson Security and Resource Management)

For this example, Lawson users and database services are configured as shown in the following table:

User/service Configuration
User1 RMId rmidUser1
User2 RMId rmidUser2
DatabaseService1 Name use_priv_svc
LoginProcedure USE_PRIVILEGED_ID
Privileged database login lawson
DatabaseService2 Name use_user_svc
LoginProcedure USE_USER_ID
rmidUser1 database login dbuser1
rmidUser2 database login dbuser2

With this configuration, the following command produces no results (no SQL is generated):

bldmsf2000secproductline use_priv_svc

However, the following syntax will result in generated SQL code:

bldmsf2000secproductline use_user_svc

The resulting SQL grants select, delete, and update on employee to dbuser1, select, delete, update on employee to dbuser2, etc.