Re: Tables in a database

[This followup was posted to comp.databases.informix and a copy was sent to the cited author.] In article <340DAB59.4643@britannic.co.uk>, fisherm@britannic.co.uk says... > > Is it possible to have 2 tables of the same name but owned by > 2 different users on 1 database? > > e.g. "fred".table1 & "jane".table1 both on db1 > > I tried it, and got an error, but wanted to make sure I was > doing it "right". > > > Mark Fisher > DBA Britannic Assurance > -- > ------------------------------------------ > The views expressed here are mine and not > those of my employer, Britannic Assurance > ------------------------------------------ > Mark I have just gone thru a project of about 1 1/2 years where we are using BusinessObjects on an Informix 7.23 system. I have not run across this problem. The way we set it up here was to create a security domain by it self. Then for each different application we created the Universe/Document domain's. Currently we have over three hundred users and 4 different applications all using the same Security domain. If you could explain you problem a bit more, I'd be glad to give you my input. If you want to go ahead and eMail me directly. Michael J. Erickson