Was this helpful?
Actian Director
Actian Director is an easy to use graphical interface that lets you interact with Actian Vector installations. Using Director, you can:
Start and stop the installation
Manage databases, tables, servers, and their components
Administer security (users, groups, roles, and profiles)
Create, store, and execute queries
You can run the Director directly on the database server, or you can download and install the Actian Director on a remote desktop running Windows or Linux.
Director components include the Director (client program) and the Management Server. One client program can be used to remotely manage any Vector instance where the Management Server is installed.
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
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.
Last modified date: 03/21/2024