Hello again ...

I think I have a solution for you ...

As mentionned in the documentation :
System Administrator Guide
Chapter 2 : Understanding Ingres components
Visual Tools
Remote Command Server : Grant access to Remote Users

you must issue some grants (mentionned in the doc), as follow :
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

In your case you must enclose your username with double quote ("), as we can
do know for table name with space in the name ...
It's look like this (ready to run with sql command line) :
grant select,insert,update,delete on $ingres.remotecmdinview to "
alessandro.azzone"\p\g
grant select,insert,update,delete on $ingres.remotecmdoutview to "
alessandro.azzone"\p\g
grant select,insert,update,delete on $ingres.remotecmdview to "
alessandro.azzone"\p\g
grant execute on procedure $ingres.launchremotecmd to "alessandro.azzone
"\p\g
grant execute on procedure $ingres.sendrmcmdinput to "alessandro.azzone"\p\g
grant register, raise on dbevent $ingres.rmcmdcmdend to "alessandro.azzone
"\p\g
grant register, raise on dbevent $ingres.rmcmdnewcmd to "alessandro.azzone
"\p\g
grant register, raise on dbevent $ingres.rmcmdnewinputline to "
alessandro.azzone"\p\g
grant register, raise on dbevent $ingres.rmcmdnewoutputline to "
alessandro.azzone"\p\g
grant register, raise on dbevent $ingres.rmcmdstp to "alessandro.azzone"\p\g

Note for Ingres developpers (my favorite community :-)
And to correct this bug in rmcmdgen the solution is perhap's to enclose
systematicly username by double quote

Hope this solve your issue ;-)
Jean-Pierre

2006/10/23, Alessandro Azzone <aleazzone (AT) hotmail (DOT) com>:

--
Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09

Hi Jean,
do you mean executing the grants as Administrator?


__________________________________________________ _______________
Windows Live Messenger:E’ arrivato.Scopri la nuova versione!
http://get.live.com/messenger/features

Administrator in the Ingres way yes, in the windows way, no.

Issue your grant on imadb via sql or isql as follow :
[isql|sql] imadb -u$ingres

all system objects are owned by the particular user "$ingres". If you try
the same on linux or unix, you must enclose $ingres by single quotes ('),
because $ mean variable

2006/10/23, Alessandro Azzone <aleazzone (AT) hotmail (DOT) com>:

--
Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09

Hi Jean,
tnx for the availability.

I tried but it does not seem to see the tables:

----------------------------------------------------------------------------------------------------------------------------------------

C:\Documents and Settings\alessandro.azzone>sql imadb -u$ingres
INGRES TERMINAL MONITOR Copyright 2005 Ingres Corporation
Ingres 2006 Microsoft Windows 32-bit Version II 9.0.4 (int.w32/105) login
Mon Oct 23 13:57:59 2006

continue
* grant select,insert,update,delete on $ingres.remotecmdinview to
"alessandro.az
zone"\p\g
/* SQL Startup File */
grant select,insert,update,delete on $ingres.remotecmdinview to
"alessandro.azzo
ne"
Executing . . .

E_US088E GRANT: Schema '$ingres' does not contain
table 'remotecmdinview' or you lack privileges on that table
which are required in order to execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
* grant select,insert,update,delete on $ingres.remotecmdoutview to
"alessandro.a
zzone"\p\g
grant select,insert,update,delete on $ingres.remotecmdoutview to
"alessandro.azz
one"
Executing . . .

E_US088E GRANT: Schema '$ingres' does not contain
table 'remotecmdoutview' or you lack privileges on that table
which are required in order to execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
* grant select,insert,update,delete on $ingres.remotecmdview to "
alessandro.azz
one"\p\g
grant select,insert,update,delete on $ingres.remotecmdview to "
alessandro.azzon
e"
Executing . . .

E_US088E GRANT: Schema '$ingres' does not contain
table 'remotecmdview' or you lack privileges on that table
which are required in order to execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
* grant execute on procedure $ingres.launchremotecmd to
"alessandro.azzone"\p\g
grant execute on procedure $ingres.launchremotecmd to "alessandro.azzone"
Executing . . .

E_US0890 GRANT: Schema '$ingres' does not contain
database procedure 'launchremotecmd' or you lack privileges
on that database procedure which are required in order to
execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
* grant execute on procedure $ingres.sendrmcmdinput to
"alessandro.azzone"\p\g
grant execute on procedure $ingres.sendrmcmdinput to "alessandro.azzone"
Executing . . .

E_US0890 GRANT: Schema '$ingres' does not contain
database procedure 'sendrmcmdinput' or you lack privileges
on that database procedure which are required in order to
execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
* grant register, raise on dbevent $ingres.rmcmdcmdend to "
alessandro.azzone"\p
\g
grant register, raise on dbevent $ingres.rmcmdcmdend to " alessandro.azzone"
Executing . . .

E_US088F GRANT: Schema '$ingres' does not contain
dbevent 'rmcmdcmdend' or you lack privileges on that dbevent
which are required in order to execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
* grant register, raise on dbevent $ingres.rmcmdnewcmd to
"alessandro.azzone"\p\
g
grant register, raise on dbevent $ingres.rmcmdnewcmd to "alessandro.azzone"
Executing . . .

E_US088F GRANT: Schema '$ingres' does not contain
dbevent 'rmcmdnewcmd' or you lack privileges on that dbevent
which are required in order to execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
* grant register, raise on dbevent $ingres.rmcmdnewinputline to
"alessandro.azzo
ne"\p\g
grant register, raise on dbevent $ingres.rmcmdnewinputline to
"alessandro.azzone
"
Executing . . .

E_US088F GRANT: Schema '$ingres' does not contain
dbevent 'rmcmdnewinputline' or you lack privileges on that dbevent
which are required in order to execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
* grant register, raise on dbevent $ingres.rmcmdnewoutputline to
"alessandro.azz
one"\p\g
grant register, raise on dbevent $ingres.rmcmdnewoutputline to
"alessandro.azzon
e"
Executing . . .

E_US088F GRANT: Schema '$ingres' does not contain
dbevent 'rmcmdnewoutputline' or you lack privileges on that dbevent
which are required in order to execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
* grant register, raise on dbevent $ingres.rmcmdstp to
"alessandro.azzone"\p\g
grant register, raise on dbevent $ingres.rmcmdstp to "alessandro.azzone"
Executing . . .

E_US088F GRANT: Schema '$ingres' does not contain
dbevent 'rmcmdstp' or you lack privileges on that dbevent
which are required in order to execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
*
----------------------------------------------------------------------------------------------------------------------------------------


P.S: is the code in the Linux release?



__________________________________________________ _______________
Condivi le tue emozioni ! http://discoverspaces.live.com/?loc=it-IT

Hi Jean,
tnx for the availability.

I tried but it does not seem to see the tables:

----------------------------------------------------------------------------------------------------------------------------------------

C:\Documents and Settings\alessandro.azzone>sql imadb -u$ingres
INGRES TERMINAL MONITOR Copyright 2005 Ingres Corporation
Ingres 2006 Microsoft Windows 32-bit Version II 9.0.4 (int.w32/105) login
Mon Oct 23 13:57:59 2006

continue
* grant select,insert,update,delete on $ingres.remotecmdinview to
"alessandro.az
zone"\p\g
/* SQL Startup File */
grant select,insert,update,delete on $ingres.remotecmdinview to
"alessandro.azzo
ne"
Executing . . .

E_US088E GRANT: Schema '$ingres' does not contain
table 'remotecmdinview' or you lack privileges on that table
which are required in order to execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
* grant select,insert,update,delete on $ingres.remotecmdoutview to
"alessandro.a
zzone"\p\g
grant select,insert,update,delete on $ingres.remotecmdoutview to
"alessandro.azz
one"
Executing . . .

E_US088E GRANT: Schema '$ingres' does not contain
table 'remotecmdoutview' or you lack privileges on that table
which are required in order to execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
* grant select,insert,update,delete on $ingres.remotecmdview to "
alessandro.azz
one"\p\g
grant select,insert,update,delete on $ingres.remotecmdview to "
alessandro.azzon
e"
Executing . . .

E_US088E GRANT: Schema '$ingres' does not contain
table 'remotecmdview' or you lack privileges on that table
which are required in order to execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
* grant execute on procedure $ingres.launchremotecmd to
"alessandro.azzone"\p\g
grant execute on procedure $ingres.launchremotecmd to "alessandro.azzone"
Executing . . .

E_US0890 GRANT: Schema '$ingres' does not contain
database procedure 'launchremotecmd' or you lack privileges
on that database procedure which are required in order to
execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
* grant execute on procedure $ingres.sendrmcmdinput to
"alessandro.azzone"\p\g
grant execute on procedure $ingres.sendrmcmdinput to "alessandro.azzone"
Executing . . .

E_US0890 GRANT: Schema '$ingres' does not contain
database procedure 'sendrmcmdinput' or you lack privileges
on that database procedure which are required in order to
execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
* grant register, raise on dbevent $ingres.rmcmdcmdend to "
alessandro.azzone"\p
\g
grant register, raise on dbevent $ingres.rmcmdcmdend to " alessandro.azzone"
Executing . . .

E_US088F GRANT: Schema '$ingres' does not contain
dbevent 'rmcmdcmdend' or you lack privileges on that dbevent
which are required in order to execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
* grant register, raise on dbevent $ingres.rmcmdnewcmd to
"alessandro.azzone"\p\
g
grant register, raise on dbevent $ingres.rmcmdnewcmd to "alessandro.azzone"
Executing . . .

E_US088F GRANT: Schema '$ingres' does not contain
dbevent 'rmcmdnewcmd' or you lack privileges on that dbevent
which are required in order to execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
* grant register, raise on dbevent $ingres.rmcmdnewinputline to
"alessandro.azzo
ne"\p\g
grant register, raise on dbevent $ingres.rmcmdnewinputline to
"alessandro.azzone
"
Executing . . .

E_US088F GRANT: Schema '$ingres' does not contain
dbevent 'rmcmdnewinputline' or you lack privileges on that dbevent
which are required in order to execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
* grant register, raise on dbevent $ingres.rmcmdnewoutputline to
"alessandro.azz
one"\p\g
grant register, raise on dbevent $ingres.rmcmdnewoutputline to
"alessandro.azzon
e"
Executing . . .

E_US088F GRANT: Schema '$ingres' does not contain
dbevent 'rmcmdnewoutputline' or you lack privileges on that dbevent
which are required in order to execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
* grant register, raise on dbevent $ingres.rmcmdstp to
"alessandro.azzone"\p\g
grant register, raise on dbevent $ingres.rmcmdstp to "alessandro.azzone"
Executing . . .

E_US088F GRANT: Schema '$ingres' does not contain
dbevent 'rmcmdstp' or you lack privileges on that dbevent
which are required in order to execute this statement.
(Mon Oct 23 13:58:00 2006)

continue
*
----------------------------------------------------------------------------------------------------------------------------------------


P.S: is the code in the Linux release?



__________________________________________________ _______________
Condivi le tue emozioni ! http://discoverspaces.live.com/?loc=it-IT

In my experience it occurs when installing as a user which has
insufficient privelege.
According to the Getting Started manual GS.pdf the installing user must:

* Be a member of local administrators group.
* Act as part of the operating system.
* Access this computer from the network
* Log on as a service.
* Debug Programs

Pre Ingres 2.6 we also needed "log on as a batch job"

Here are some things to check:

Is imadb owned by $ingres?
Run
infodb imadb

Check out the first couple of lines. They should show something like:

Database : (imadb,$ingres) ....


Who owns the view remotecmdinview?
Run
sql imadb
* help view remotecmdinview

In my installations, the view is owned by ingres. (I think because I
installed as user ingres) So I would guess this would be correct.

grant select,insert,update,delete on
ingres.remotecmdinview to "alessandro.azzone"\p\g


Who are the administrators listed in config.dat? Look for these entries
which will allow you to stop and restart ingres services.

notepad %II_SYSTEM%\ingres\files\config.dat
...
ii.*.privileges.user.administrator:
SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED
ii.*.privileges.user.ingres:
SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED
...

Hope this helps.