suggestion about php ocilogon() oracle OCI FUNCTION

From: Date: Mon, 27 Oct 2003 14:10:37 +0000
Subject: suggestion about php ocilogon() oracle OCI FUNCTION
Groups: php.db 
Request: Send a blank email to php-db+get-31309@lists.php.net to get a copy of this message
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.

« previous php.db (#31309) next »