Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

In VDBA creating a database as a user other than ingres fails with error E_US0DAE?

April 26, 2017creating database Error fails ingres user

0

Posted

In VDBA creating a database as a user other than ingres fails with error E_US0DAE?

1 Answer

0

Posted

This happens if the user has not been given grants to the remotecmd tables and associated dbevents. To allow a user other than the ‘ingres’ user to be able to execute the remote commands. For 1.2, 2.0. 2.5 issue the following SQL statements while connected to the iidbdb as the ‘ingres’ user, however for 2.6 these grants need to be issued as the user ‘ingres’ while connected to the imadb database: grant select,insert,update,delete on remotecmdinview to grant select,insert,update,delete on remotecmdoutview to grant select,insert,update,delete on remotecmdview to grant execute on procedure launchremotecmd to grant execute on procedure sendrmcmdinput to grant register,raise on dbevent rmcmdcmdend to grant register,raise on dbevent rmcmdnewcmd to grant register,raise on dbevent rmcmdnewinputline to grant register,raise on dbevent rmcmdnewoutputline to grant register,raise on dbevent rmcmdstp to Note that NO grants should