AW: [PHP-DEV] PHP 4.0 Bug #8767: user name prepended to table names in query

hi i've never worked with informix, but afaik from other 'big' DBs you have to prepend the owner of the requested object (e.g. the table) or create an alias to the object for every user that wants to access it. because if now owner is specified the client assumes that the actual user owns the requestet object and prepends it. try something like select * from [ownerofthetable].action > -----Ursprüngliche Nachricht----- > Von: david.rhodes@mail1.monmouth.army.mil > [mailto:david.rhodes@mail1.monmouth.army.mil] > Gesendet: Mittwoch, 17. Jänner 2001 21:42 > An: php-dev@lists.php.net > Betreff: [PHP-DEV] PHP 4.0 Bug #8767: user name prepended to table names > in query > > > From: david.rhodes@mail1.monmouth.army.mil > Operating system: RH 6.2 > PHP version: 4.0.3pl1 > PHP Bug Type: Informix related > Bug description: user name prepended to table names in query > > I folks, I have searched many sources for a few days looking for > an answer to no avail. I have what seems to be a properly > configured setup of Redhat 6.2, PHP 4.0.3pl1, Informix Dyn Server > 7.30. At this point I am trying to build a simple database > browser. Using ifx_{connect, query, close} I can query a database > in the 'informix.systables' and get results, using a particular > db@server, uname, passwd in the ifx_connect call. However, using > the same parameters a simple query, such as: > > select * from action > > always fails with code > > (E [SQLSTATE=42 000 SQLCODE=-206]) > string: The specified table (uname.action) is not in the database > > If I use different db/server or uname or passwds, I get the > expected error messages regarding the error. It seems that the > user name (2nd parameter in ifx_connect call) is being prepended > to the table request for some reason??? Running the same query > from "dbaccess" works. I have not seen this error mentioned > anywhere in user groups, web sites, etc. > > Thanks for any help, > dave > > > > -- > Edit Bug report at: http://bugs.php.net/?id=8767&edit=1 > > > > -- > PHP Development Mailing List <http://www.php.net/> > To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net > For additional commands, e-mail: php-dev-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >