2. Understanding Ingres Components : Visual Tools (Windows) : Remote Command Server : Grant Access to Remote Users
 
Share this page                  
Grant Access to Remote Users
To allow a user other than the installation owner to execute remote commands, you can use the following methods:
In Actian Director, use the Create User or Modify User dialog, select Options, Remote Command Privileges
In VDBA, use the Create or Alter User dialog. Enable the Remote Command (rmcmd) Privileges checkbox.
You can execute the following SQL statements, while connected to the imadb database as the installation owner:
grant select,insert,update,delete on $ingres.remotecmdinview to user
grant select,insert,update,delete on $ingres.remotecmdoutview to user
grant select,insert,update,delete on $ingres.remotecmdview to user
grant execute on procedure $ingres.launchremotecmd to user
grant execute on procedure $ingres.sendrmcmdinput to user
grant register, raise on dbevent $ingres.rmcmdcmdend to user
grant register, raise on dbevent $ingres.rmcmdnewcmd to user
grant register, raise on dbevent $ingres.rmcmdnewinputline to user
grant register, raise on dbevent $ingres.rmcmdnewoutputline to user
grant register, raise on dbevent $ingres.rmcmdstp to user
Note:  Grants must not be made directly to the underlying tables.