The STRSQL command, which can be limited using Command Security, can be setup using the following procedure.
On the PowerTech Command Security menu, select option 1, Work with Monitored Commands.
On the Work with Monitored Commands panel, press F6, Create, to display the Select Commands panel. Locate the STRSQL command and enter a 1 to select it.
With the STRSQL command on the Work with Monitored Commands panel, Enter an 8=Rules, next to the command. The Work with Rules panels displays, allowing you to start defining the conditions and actions for the command.
Press F6, New Rule, to display the Work with Rule Conditions panel. Press F6, New Condition, to define a condition.
On the Create Condition panel, enter the following values:
Data Source: *USER
Compare to: NUSER
When you press Enter and return to the Work with Rule Conditions panel, the condition you entered appears on the panel. Now, press F11, Actions, to define the Actions for the Rule.
On the Work with Rule Actions panel, press F6, New Action, to display the Create Action panel.
On the Create Action panel, enter the following values:
Press Enter to save the action and return to the Work with Rule Actions panel.
When activated, the rule will prevent the user ‘NUSER’ from executing the command STRSQL.