Hello,

we are working with an "old" Ingres II 2.6 and
i wanted to create a new db user with "select" rights on 3 databases,
so i started to create a GRANT script like this:

select 'grant select on '+squeeze(table_name)+' to username'+';
commit;' from iitables where table_owner = 'myowner' AND (table_type=
'T' OR table_type = 'V');

The Result is a large script with all GRANT SELECTs for all tables ;-)

I executed this script and everything looks fine, but i cant access
the databases with Ingres.Net from a client pc.

So i started reading a lot of documentation and learned that i have to
create the same user in the HP-UX environment
to connect to the database server via Ingres.Net. But this does not
work.
I cant access the database. Is there any rightsmanagement on the
ingres server side where i can enable this user to acces remotely?

Thank you in advance

Johannes Nissen

Are these databases private or public?

If private did you grant the new username access to the databases.

Marty

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Johannes
Sent: 04 February 2010 15:20
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: [Info-Ingres] How to create a "read only" user with IngresNET
login?

Hello,

we are working with an "old" Ingres II 2.6 and
i wanted to create a new db user with "select" rights on 3 databases,
so i started to create a GRANT script like this:

select 'grant select on '+squeeze(table_name)+' to username'+';
commit;' from iitables where table_owner = 'myowner' AND (table_type=
'T' OR table_type = 'V');

The Result is a large script with all GRANT SELECTs for all tables ;-)

I executed this script and everything looks fine, but i cant access
the databases with Ingres.Net from a client pc.

So i started reading a lot of documentation and learned that i have to
create the same user in the HP-UX environment
to connect to the database server via Ingres.Net. But this does not
work.
I cant access the database. Is there any rightsmanagement on the
ingres server side where i can enable this user to acces remotely?

Thank you in advance

Johannes Nissen
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

Usually you would - before GRANTing anything to a user - start with
creating the user both on OS level (which you now did) AND in the DB
installation.
The latter is done by either using "accessdb" or using the "CREATE
USER" SQL statement (run against database iidbdb).


--
Bodo

On 4 Feb., 16:36, "Martin Bowes" <martin.bo... (AT) ctsu (DOT) ox.ac.uk> wrote:
Yes i did, but only the "access database" right, no other privilegs.
The others don't seem to affect the login procedure, or i am wrong?

Thank you

On 4 Feb., 17:31, Ingres Forums <info-
ing... (AT) kettleriverconsulting (DOT) com> wrote:
Thank you Bodo,

tomorrow I will try it in your recommended order again.
I used the CREATE USER statement and will take a look at the accessdb
command.

Johannes

Good Morning,

now it seems i am near my goal, i don't get the login error any more:

E_LQ0001 Failed to connect to DBMS session.
E_LC0001 GCA protocol service (GCA_REQUEST) failure.
Internal service status E_GC000b -- Remote login failure: invalid
password/userid. If using installation passwords, please make sure
all
servers are 6.4/02 or newer and that they have been started by the
installation owner..


But now I get this meassage box under Ingres ODBC Administrator:

Caution failed. - Database Name Browser
[CA][Ingres ODBC Driver][Ingres]User authorization check failed.
Your user identifier was not known to this installation.
Contact your system manager for further assistance.

Does this refer to the Ingre/Net installation on the XP Client,
or to the server authentication?


Johannes

What is the actual error message your new user is getting when trying to
connect?
Can other (existing) users connect via Ingres/Net?


--
Bodo

Hi Bodo,

the actual message is:

Caution failed. - Database Name Browser
[CA][Ingres ODBC Driver][Ingres]User authorization check failed.
Your user identifier was not known to this installation.
Contact your system manager for further assistance.

If I take an other existing user, it works fine.

The Databases are shown in the Database Select Field,
but not with my new created user.

If i look in the errlog.log on the Ingres Server side,
i can't see anymore login failure messages.

Johannes

Hi Johannes,

You need to ensure the username is created on the installation you are
connecting to.

Marty

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Johannes
Sent: 05 February 2010 09:24
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: Re: [Info-Ingres] How to create a "read only" user with
IngresNETlogin?

Hi Bodo,

the actual message is:

Caution failed. - Database Name Browser
[CA][Ingres ODBC Driver][Ingres]User authorization check failed.
Your user identifier was not known to this installation.
Contact your system manager for further assistance.

If I take an other existing user, it works fine.

The Databases are shown in the Database Select Field,
but not with my new created user.

If i look in the errlog.log on the Ingres Server side,
i can't see anymore login failure messages.

Johannes

_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

Hello Marty,

I checked "cat /etc/passwd" and my new User is created in the Unix
environment on the Ingres DB Server.
The password also is correct, i tried "su newuser" and entered the
password.

Johannes