Ingres NET and DB_ADMIN Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stephane Beaudry - 23 Jan 2004 19:18 GMT

We are using Open Ingres 2.0 on Open VMS, just recently we installed Ingres
NET, I was able to configure Ingres NET and retrive data on my Desktop, but
I simply can't figure out how to use the "-U" parameter. Due to security
concerns, I don't have the Password for our production account that owns the
database that I am attempting to connect to, in VMS I would simply issue
"isql dbname -Udba" and have full access. How do I get the same results
through my desktop, thanks.

Reply to this Message

Mason, Paul - 26 Jan 2004 10:53 GMT

Stephane,

It's the same process only now you'd do

isql vnode::dbname -udba

on your desktop. The important thing is that the user defined in the
vnode has security administrator privileges on the VMS machine. The one
you logged in as on VMS that allowed you to use -U must've had this
privilege.

By the way, having security administrator privilege is probably more
powerful than having the dba password - unless the dba is also the
ingres system administrator.

HTH
Paul

> -----Original Message-----
> From: owner-info-ingres@ams.org
[quoted text clipped - 11 lines]
> simply issue "isql dbname -Udba" and have full access. How
> do I get the same results through my desktop, thanks.

Reply to this Message