Public synonyms probably provide the best solution for a lot of issues
associated with Owner of database objects. Only for Synonyms ND doesn't
attach the owner name to the object name, make it more like things were with
ND3.
For simple situations, however, you can use the Runtime Userid/Password
feature of ND Studio. The Studio UserId/password is for connecting you to
oracle while you are working on the Studio, and the run-time stuff is for
connecting when you run the application. ND does take the trouble to do a
find-and-replace at run-time, changing from Studio UID/PW to runtime stuff.
I mean, if you set studio user-id as 'dev' and runtime user-id as 'prod',
you see dev.emptable in Studio, but at run-time ND changes it to
prod.emptable.
Aby
TeamND
> -----Original Message-----
> From: suyoto [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 26, 1999 12:21 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [ND] Problem with Oracle owner
>
>
>
> We ran into the similar problem. We ended up creating a synonym
> on the database for zzz to point to yyy.
>
> There is a doc somewhere that mention to add
> StudioDBOwner "yyy" ;
> RuntimeDBOwner "yyy" ;
> to the data source sds file manually. It seems logical that
> this would cause the generated sql to be 'yyy.fee.foo' for
> the zzz user id. We tried this to no avail.
>
> If you try this approach, kindly let me know how it turns out.
>
> Suyoto Tandio
>
> "Hoskins, John D." <[EMAIL PROTECTED]> wrote:
> >ND4.1.3.8, NT4
> >
> >Here's the deal.
> >If I take the data source, change the studioProperties, and the
> >studioPassword, but not the studioUserID, when run, the data
> objects retain
> >the original owner when creating the SQL.
> >As soon as I change the StudioUserID and run it, the data
> objects use this
> >new studioUserID as the owner. Any way around this? Why
> would it do this?
> >
> >Example:
> >before, with the studio db owner set to abc:
> >select yyy.fee.foo from yyy.fee
> >after changing the db owner to zzz:
> >select zzz.fee.foo from zzz.fee
> >
> >> John Hoskins
> >> TDS Computing Services
> >> Application Development & Support Team
> >> [EMAIL PROTECTED]
> >> 608.664.8263
> >> 608.664.8288 (fax)
> >>
>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
