At 12:44 PM 10/12/2004 +1100, you wrote:

> > Or a limitation...when you are logged into the embedded server,
> > you are "no
> > user", even if your application login passed them into the
> > application. Any
> > user can create an object. However, by default, a database
> > object can only
> > be accessed by its creator or SYSDBA.
> >
>
>Hmm,... I don't know what the difference is with my system but when I log
>thru my embedded server to a database and I do not supply a username, the
>USER is SYSDBA whether I like it or not.
>I have tested this with UPDATE triggers.

Yep, this will be the case if you have the envvars ISC_USER and
ISC_PASSWORD defined (as I discovered a couple of days ago when fiddling
about with the backup service.)

./hb