Re: Can I ? - XSQL dynamic database connection

On 30 Jul 2002, c.wilson_at_lbs-ltd.com wrote:
> How do you write XSQL without knowledge of username and
> passwords.

I don't believe this is possible.

> The physical user will be supplying their DbUser and DbPassword
> in a web login page and these are to be used throughout the web
> application.
>
> XSQL requires a connection alias. i.e. "demo"
>
> <page xmlns:xsql="urn:oracle-xsql" connection="demo" >
> <xsql:query max-rows="-1" null-indicator="no"
> row-element="USER" rowset-element="" tag-case="upper"> select
> user from sys.dual </xsql:query> </page>
>
> But I need to set the username and password for "demo" in
> runtime.
>
> (Reason: Each database user has specific roles and limits on
> viewable information)

Will you have a distinct set of these "types" of users? Can you have a login for each type? Then you could have an xsql page which queries a table telling you the "type" of user and then sets the connection parameter based on the "type" found.

-- 
Galen Boyer