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):

bldora11sec / bldora12secproductline use_priv_svc

bldora11sec productline use_priv_svc

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

bldora11sec / bldora12secproductline use_user_svc

bldora11sec productline use_user_svc

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