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.