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: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Gesendet: Mittwoch, 17. Jänner 2001 21:42
> An: [EMAIL PROTECTED]
> Betreff: [PHP-DEV] PHP 4.0 Bug #8767: user name prepended to table names
> in query
>
>
> From: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
