I'm using php/oracle9.2 .
i cant' login into oracle db using ocilogon() as "SYS" user.
so, i examed oci8.c source.
above 9i , in order to login as "SYS" user
5th parameter of OCISessionBegin must be "OCI_SYSDBA"(not OCI_DEFAULT);
-----------------------------------------------------------------
oci8.c
-----------------------------------------------------------------
2315: CALL_OCI_RETURN(OCI(error), OCISessionBegin(
2316: svchp,
2317: OCI(pError),
2318: session->pSession,
2319: (ub4) OCI_CRED_RDBMS,
2320: (ub4) OCI_DEFAULT)); <=========== OCI_DEFAULT|OCI_SYSDBA|OCI_SYSOPER
// OCI_SYSDBA -- in this mode, the user is authenticated for SYSDBA
// access.
// OCI_SYSOPER -- in this mode, the user is authenticated
// for SYSOPER access.
-----------------------------------------------------------------------------------
my suggestion !!
PHP ocilogon specification
resource ocilogon ( string username, string password [, string db] )
==> new 4th parameter!
resource ocilogon ( string username, string password [, string db],sesson_mode=OCI_DEFAUL)
--------------------------
ocilogon("SYS","change_on_install","mydb", OCI_SYSOPER );
---------------
is it possible ?( i'm poor at C programming).
sorry for my rudness & poor english.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
