[Info-Ingres] vnode 'read-only' connection attribute

Hi all,



Is there a connection attribute I can specify on a vnode so that its
read-only?



Martin Bowes

Hi,
You mean, you want to specify in the vnode, that the session is a
read-only session?
I can't imagine how this should work. A vnode is used to establish a
connection, thats all. And even when we could specify an initial sql
command to be executed(to set the session read-only), the user could
overwrite this by an additional SQL command.

Regards
Kristoff


On Oct 23, 1:31 pm, "Martin Bowes" wrote:
> Hi all,
>
> Is there a connection attribute I can specify on a vnode so that its
> read-only?
>
> Martin Bowes

Yep, I came to that conclusion myself shortly after I posted it.

I decided it was easier to make select grants on the tables for the
specific user the vnode authenticates as.

Marty

-----Original Message-----
From: info-ingres-bounces-at-kettleriverconsulting.com
[mailto:info-ingres-bounces-at-kettleriverconsulting.com] On Behalf Of
Kristoff
Sent: 24 October 2008 08:51
To: info-ingres-at-kettleriverconsulting.com
Subject: Re: [Info-Ingres] vnode 'read-only' connection attribute

Hi,
You mean, you want to specify in the vnode, that the session is a
read-only session?
I can't imagine how this should work. A vnode is used to establish a
connection, thats all. And even when we could specify an initial sql
command to be executed(to set the session read-only), the user could
overwrite this by an additional SQL command.

Regards
Kristoff


On Oct 23, 1:31 pm, "Martin Bowes" wrote:
> Hi all,
>
> Is there a connection attribute I can specify on a vnode so that its
> read-only?
>
> Martin Bowes

_______________________________________________
Info-Ingres mailing list
Info-Ingres-at-kettleriverconsulting.com
http://www.kettleriverconsulting.com...fo/info-ingres