albertborsos/yii2-oracle-dbmanager

overrided \yii\rbac\DbManager for Oracle


Keywords
yii2, dbmanager, authmanager

Documentation

Yii2 DbManager class for Oracle databases

Warning: Yii2 is in beta version

I can not guarantee that this package is up-to-date to Yii2 beta framework.

Description

Oracle required that a table column name to be uppercase. I updated the original \yii\rbac\DbManager class's every attributes name, and included the missing classes because of the new namespace.

  • schema with uppercase letters and Oracle specific syntax for generating the required tables

Installation

1.) Download via packagist by adding the following line to your composer.json

    "require": {
        "albertborsos/yii2-oracle-dbmanager": "*"
    },

2.) Add or update the following component to your config file:

'components' => [
    ...
    'authManager' => [
        'class' => 'vendor\albertborsos\yii2oracledbmanager\DbManager',
        'itemTable' => 'TBL_AUTH_ITEM',
        'itemChildTable' => 'TBL_AUTH_ITEM_CHILD',
        'assignmentTable' => 'TBL_AUTH_ASSIGNMENT',
        'ruleTable' => 'TBL_AUTH_RULE',
    ],
    ...
],

3.) Create the tables by the schema-oracle.sql script