Granting Permissions to Lawson System Foundation Tables in Landmark
The buildschemaviewperms
utility generates
a SQL script granting permissions to another user or role for all
tables in a database space marked IsView=Yes
in the
data area deployment file. After generating the script, you run the
script using a SQL utility to grant the desired permissions.
Run this script any time a structural change resulting from
a blddbdict
or database reorganization occurs to Infor Lawson System Foundation tables
that are marked as IsView
in the Infor Landmark Technology data
area deployment file.
Before running this utility, all Infor Lawson System Foundation tables used by Infor Landmark Technology must
be set to IsView=Yes
in the appropriate section of the
database deployment file (%LACFGDIR%\dict\dataarea.xml
). This
deployment file is modified using the changeda
utility.
Changing Database Space Attributes Using changeda
To Grant Permissions to Infor Lawson System Foundation Tables in Landmark