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]
