ORA-28009 |
Hi everyone
I have started CodeIgniter recently and I have a problem connecting to my DB (Oracle) Indeed I have an error message telling me that I have to connect as SYSDBA or SYSOPER. I have read a topic from this forum but he is from 2012 and the links doesn't help. This is the error message : Message: oci_connect(): ORA-28009: connection as SYS should be as SYSDBA or SYSOPER Filename: oci8/oci8_driver.php Line Number: 239 If someone could help me that would be great, this is for my diploma work. Thank you PS : I already had this problem in "simple" php, I fixed it by puting the session_mode argument in the "oci_connect" function.
Personally I would do as the error message says and create a user that don't have global rights. That's a huge security risk.
Or set oci8.privileged_connect in php.ini http://php.net/manual/en/oci8.configurat...ed-connect Or hack \system\database\drivers\oci8\oci8_driver.php PHP Code: public function db_connect($persistent = FALSE)
I have found
I just had to add the variable "session_mode". Like this : PHP Code: public function db_connect($persistent = TRUE) And in "database.php" : PHP Code: $db['default'] = array( (SESSION MODE : 2 --> SYSDBA, 4 --> SYSOPER) |
Welcome Guest, Not a member yet? Register Sign In |