buildschemaviewperms - Build Script to Grant a Lawson User Permissions for Lawson System Foundation Tables

buildschemaviewperms -u application_user|role [-s] dataarea [file|module...] > permsscriptname.sql

The buildschemaviewperms utility generates a SQL script granting permissions to another user or role for tables in a database space marked IsView=Yes. After generating the script, run it using a SQL command utility to grant the desired permissions.

Before you run this utility, all Infor Lawson System Foundation tables must be set to IsView=Yes in the %LARUNDIR%\dataarea\db.cfg file.

Parameter	Description
-u application_user|role	The user or role needing the rights to views.
-s	Grant select permission only.
dataarea	The product line that contains the application.
file | module	A specific business class, module, database space, or business class pattern to execute the command against. Wildcard characters can also be used in order to specify multiple business classes.
permsscriptname	The name of the script that will grant permissions to the Infor Lawson System Foundation tables.