Cdbauthmanager Error With Oracle Database
Posted 01 October 2012 - 04:15 AM
I start using yii authorization feature,
:using ORACLE 10g
:using last yii version (got from svn)
:has created table AuthAssignment,AuthItem and AuthItemChild, using schema in framework
:has setup in main.php(config), component authManager
- role authenticated, bizRule=> 'return !Yii::app()->user->isGuest;'
- role guest, bizRule => 'return Yii::app()->user->isGuest;'
:has assign userid and role name using $auth->assign('admin',1);, 1 is the userid one of my user
:put Yii::app()->user->checkAccess('admin') at the beginning one of my controller
The problem is.. I got error like this :
CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]  OCIStmtExecute: ORA-00904: "USERID": invalid identifier. The SQL statement executed was: SELECT *
for comparation, above mentioned error would not happen when I use sqlite database for the authManager db.
Could someone help me? or face the same problem with me? I still hope can use oracle db for authManager db.
Posted 01 October 2012 - 04:59 AM
Posted 01 October 2012 - 03:10 PM
CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]  OCIStmtExecute: ORA-00911: invalid character. The SQL statement executed was: SELECT *