Thanks Helen


Plus one it only asks with user and the same rule or either I have that to close always the connection if I to want to also change of user?

Grateful for the attention


Edmilson

----- Original Message -----
From: Helen Borrie
To: IBObjects@yahoogroups.com
Sent: Tuesday, October 11, 2005 9:41 PM
Subject: Re: [IBO] To change ROLE without closing the possible connection and?


At 06:25 PM 11/10/2005 -0300, you wrote:
>Hi all,
>
>It would like to know if it has as I to change ROLE of the IBODataBase
>without closing the connection therefore already

No. ROLE (if used) is unconditionally an attribute of a database connection.

>I have a connected user so I would like to change I ROLE it for mine app.
>I tried IBODATABASE.LoginSQLROLE: = ' NewROLE ' and also
>IBODATABAse.SQLROLE:='NewROLE '; with hardwired IBODATABASE, when
>I make this I finish receiving an error it delphi

It is not supported. Period. It's nothing to do with Delphi or IBO. It
is the way SQL privileges work, by design.

>I
>Use IBO 4.3Aa + delphi 7 + Firebird 1.5
>Or I would have obligatorily that to close the connection to change ROLE?

Yes.

Helen




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !



------------------------------------------------------------------------------
YAHOO! GROUPS LINKS

a.. Visit your group "IBObjects" on the web.

b.. To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


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



[Non-text portions of this message have been removed]