ranger-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From v..@apache.org
Subject [3/5] incubator-ranger git commit: RANGER-239: Support JDBC based SQL invocation for setup process
Date Thu, 19 Feb 2015 20:11:47 GMT
http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/mysql/xa_db.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/mysql/xa_db.sql b/security-admin/db/mysql/xa_db.sql
new file mode 100644
index 0000000..4b2919f
--- /dev/null
+++ b/security-admin/db/mysql/xa_db.sql
@@ -0,0 +1,778 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements.  See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License.  You may obtain a copy of the License at
+--
+--     http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
+-- MySQL dump 10.13  Distrib 5.1.50, for apple-darwin10.3.0 (i386)
+--
+-- Host: localhost    Database: xa_db
+-- ------------------------------------------------------
+-- Server version	5.1.50
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+--
+-- Current Database: `xa_db`
+--
+
+/*!40000 DROP DATABASE IF EXISTS `xa_db`*/;
+
+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `xa_db` /*!40100 DEFAULT CHARACTER SET latin1 */;
+
+USE `xa_db`;
+
+--
+-- Temporary table structure for view `vx_trx_log`
+--
+
+DROP TABLE IF EXISTS `vx_trx_log`;
+/*!50001 DROP VIEW IF EXISTS `vx_trx_log`*/;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+/*!50001 CREATE TABLE `vx_trx_log` (
+  `id` bigint(20),
+  `create_time` datetime,
+  `update_time` datetime,
+  `added_by_id` bigint(20),
+  `upd_by_id` bigint(20),
+  `class_type` int(11),
+  `object_id` bigint(20),
+  `parent_object_id` bigint(20),
+  `parent_object_class_type` int(11),
+  `attr_name` varchar(255),
+  `parent_object_name` varchar(1024),
+  `object_name` varchar(1024),
+  `prev_val` varchar(1024),
+  `new_val` varchar(1024),
+  `trx_id` varchar(1024),
+  `action` varchar(255),
+  `sess_id` varchar(512),
+  `req_id` varchar(30),
+  `sess_type` varchar(30)
+) ENGINE=MyISAM */;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Table structure for table `x_asset`
+--
+
+DROP TABLE IF EXISTS `x_asset`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `x_asset` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `create_time` datetime DEFAULT NULL,
+  `update_time` datetime DEFAULT NULL,
+  `added_by_id` bigint(20) DEFAULT NULL,
+  `upd_by_id` bigint(20) DEFAULT NULL,
+  `asset_name` varchar(1024) NOT NULL,
+  `descr` varchar(4000) NOT NULL,
+  `act_status` int(11) NOT NULL DEFAULT '0',
+  `asset_type` int(11) NOT NULL DEFAULT '0',
+  `config` text,
+  `sup_native` tinyint(1) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`),
+  KEY `x_asset_FK_added_by_id` (`added_by_id`),
+  KEY `x_asset_FK_upd_by_id` (`upd_by_id`),
+  KEY `x_asset_cr_time` (`create_time`),
+  KEY `x_asset_up_time` (`update_time`),
+  CONSTRAINT `x_asset_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_asset_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `x_asset`
+--
+
+LOCK TABLES `x_asset` WRITE;
+/*!40000 ALTER TABLE `x_asset` DISABLE KEYS */;
+/*!40000 ALTER TABLE `x_asset` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `x_audit_map`
+--
+
+DROP TABLE IF EXISTS `x_audit_map`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `x_audit_map` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `create_time` datetime DEFAULT NULL,
+  `update_time` datetime DEFAULT NULL,
+  `added_by_id` bigint(20) DEFAULT NULL,
+  `upd_by_id` bigint(20) DEFAULT NULL,
+  `res_id` bigint(20) DEFAULT NULL,
+  `group_id` bigint(20) DEFAULT NULL,
+  `user_id` bigint(20) DEFAULT NULL,
+  `audit_type` int(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`),
+  KEY `x_audit_map_FK_added_by_id` (`added_by_id`),
+  KEY `x_audit_map_FK_upd_by_id` (`upd_by_id`),
+  KEY `x_audit_map_FK_res_id` (`res_id`),
+  KEY `x_audit_map_FK_group_id` (`group_id`),
+  KEY `x_audit_map_FK_user_id` (`user_id`),
+  KEY `x_audit_map_cr_time` (`create_time`),
+  KEY `x_audit_map_up_time` (`update_time`),
+  CONSTRAINT `x_audit_map_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_audit_map_FK_group_id` FOREIGN KEY (`group_id`) REFERENCES `x_group` (`id`),
+  CONSTRAINT `x_audit_map_FK_res_id` FOREIGN KEY (`res_id`) REFERENCES `x_resource` (`id`),
+  CONSTRAINT `x_audit_map_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_audit_map_FK_user_id` FOREIGN KEY (`user_id`) REFERENCES `x_user` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `x_audit_map`
+--
+
+LOCK TABLES `x_audit_map` WRITE;
+/*!40000 ALTER TABLE `x_audit_map` DISABLE KEYS */;
+/*!40000 ALTER TABLE `x_audit_map` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `x_auth_sess`
+--
+
+DROP TABLE IF EXISTS `x_auth_sess`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `x_auth_sess` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `create_time` datetime DEFAULT NULL,
+  `update_time` datetime DEFAULT NULL,
+  `added_by_id` bigint(20) DEFAULT NULL,
+  `upd_by_id` bigint(20) DEFAULT NULL,
+  `login_id` varchar(767) NOT NULL,
+  `user_id` bigint(20) DEFAULT NULL,
+  `ext_sess_id` varchar(512) DEFAULT NULL,
+  `auth_time` datetime NOT NULL,
+  `auth_status` int(11) NOT NULL DEFAULT '0',
+  `auth_type` int(11) NOT NULL DEFAULT '0',
+  `auth_provider` int(11) NOT NULL DEFAULT '0',
+  `device_type` int(11) NOT NULL DEFAULT '0',
+  `req_ip` varchar(48) NOT NULL,
+  `req_ua` varchar(1024) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `x_auth_sess_FK_added_by_id` (`added_by_id`),
+  KEY `x_auth_sess_FK_upd_by_id` (`upd_by_id`),
+  KEY `x_auth_sess_FK_user_id` (`user_id`),
+  KEY `x_auth_sess_cr_time` (`create_time`),
+  KEY `x_auth_sess_up_time` (`update_time`),
+  CONSTRAINT `x_auth_sess_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_auth_sess_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_auth_sess_FK_user_id` FOREIGN KEY (`user_id`) REFERENCES `x_portal_user` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `x_auth_sess`
+--
+
+LOCK TABLES `x_auth_sess` WRITE;
+/*!40000 ALTER TABLE `x_auth_sess` DISABLE KEYS */;
+/*!40000 ALTER TABLE `x_auth_sess` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `x_cred_store`
+--
+
+DROP TABLE IF EXISTS `x_cred_store`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `x_cred_store` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `create_time` datetime DEFAULT NULL,
+  `update_time` datetime DEFAULT NULL,
+  `added_by_id` bigint(20) DEFAULT NULL,
+  `upd_by_id` bigint(20) DEFAULT NULL,
+  `store_name` varchar(1024) NOT NULL,
+  `descr` varchar(4000) NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `x_cred_store_FK_added_by_id` (`added_by_id`),
+  KEY `x_cred_store_FK_upd_by_id` (`upd_by_id`),
+  KEY `x_cred_store_cr_time` (`create_time`),
+  KEY `x_cred_store_up_time` (`update_time`),
+  CONSTRAINT `x_cred_store_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_cred_store_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `x_cred_store`
+--
+
+LOCK TABLES `x_cred_store` WRITE;
+/*!40000 ALTER TABLE `x_cred_store` DISABLE KEYS */;
+/*!40000 ALTER TABLE `x_cred_store` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `x_db_base`
+--
+
+DROP TABLE IF EXISTS `x_db_base`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `x_db_base` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `create_time` datetime DEFAULT NULL,
+  `update_time` datetime DEFAULT NULL,
+  `added_by_id` bigint(20) DEFAULT NULL,
+  `upd_by_id` bigint(20) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `x_db_base_FK_added_by_id` (`added_by_id`),
+  KEY `x_db_base_FK_upd_by_id` (`upd_by_id`),
+  KEY `x_db_base_cr_time` (`create_time`),
+  KEY `x_db_base_up_time` (`update_time`),
+  CONSTRAINT `x_db_base_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_db_base_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `x_db_base`
+--
+
+LOCK TABLES `x_db_base` WRITE;
+/*!40000 ALTER TABLE `x_db_base` DISABLE KEYS */;
+/*!40000 ALTER TABLE `x_db_base` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `x_group`
+--
+
+DROP TABLE IF EXISTS `x_group`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `x_group` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `create_time` datetime DEFAULT NULL,
+  `update_time` datetime DEFAULT NULL,
+  `added_by_id` bigint(20) DEFAULT NULL,
+  `upd_by_id` bigint(20) DEFAULT NULL,
+  `group_name` varchar(1024) NOT NULL,
+  `descr` varchar(4000) NOT NULL,
+  `status` int(11) NOT NULL DEFAULT '0',
+  `group_type` int(11) NOT NULL DEFAULT '0',
+  `group_src` int(11) NOT NULL DEFAULT '0',
+  `cred_store_id` bigint(20) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `x_group_FK_added_by_id` (`added_by_id`),
+  KEY `x_group_FK_upd_by_id` (`upd_by_id`),
+  KEY `x_group_FK_cred_store_id` (`cred_store_id`),
+  KEY `x_group_cr_time` (`create_time`),
+  KEY `x_group_up_time` (`update_time`),
+  CONSTRAINT `x_group_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_group_FK_cred_store_id` FOREIGN KEY (`cred_store_id`) REFERENCES `x_cred_store` (`id`),
+  CONSTRAINT `x_group_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `x_group`
+--
+
+LOCK TABLES `x_group` WRITE;
+/*!40000 ALTER TABLE `x_group` DISABLE KEYS */;
+/*!40000 ALTER TABLE `x_group` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `x_group_groups`
+--
+
+DROP TABLE IF EXISTS `x_group_groups`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `x_group_groups` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `create_time` datetime DEFAULT NULL,
+  `update_time` datetime DEFAULT NULL,
+  `added_by_id` bigint(20) DEFAULT NULL,
+  `upd_by_id` bigint(20) DEFAULT NULL,
+  `group_name` varchar(1024) NOT NULL,
+  `p_group_id` bigint(20) DEFAULT NULL,
+  `group_id` bigint(20) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `x_group_groups_FK_added_by_id` (`added_by_id`),
+  KEY `x_group_groups_FK_upd_by_id` (`upd_by_id`),
+  KEY `x_group_groups_FK_p_group_id` (`p_group_id`),
+  KEY `x_group_groups_FK_group_id` (`group_id`),
+  KEY `x_group_groups_cr_time` (`create_time`),
+  KEY `x_group_groups_up_time` (`update_time`),
+  CONSTRAINT `x_group_groups_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_group_groups_FK_group_id` FOREIGN KEY (`group_id`) REFERENCES `x_group` (`id`),
+  CONSTRAINT `x_group_groups_FK_p_group_id` FOREIGN KEY (`p_group_id`) REFERENCES `x_group` (`id`),
+  CONSTRAINT `x_group_groups_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `x_group_groups`
+--
+
+LOCK TABLES `x_group_groups` WRITE;
+/*!40000 ALTER TABLE `x_group_groups` DISABLE KEYS */;
+/*!40000 ALTER TABLE `x_group_groups` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `x_group_users`
+--
+
+DROP TABLE IF EXISTS `x_group_users`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `x_group_users` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `create_time` datetime DEFAULT NULL,
+  `update_time` datetime DEFAULT NULL,
+  `added_by_id` bigint(20) DEFAULT NULL,
+  `upd_by_id` bigint(20) DEFAULT NULL,
+  `group_name` varchar(1024) NOT NULL,
+  `p_group_id` bigint(20) DEFAULT NULL,
+  `user_id` bigint(20) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `x_group_users_FK_added_by_id` (`added_by_id`),
+  KEY `x_group_users_FK_upd_by_id` (`upd_by_id`),
+  KEY `x_group_users_FK_p_group_id` (`p_group_id`),
+  KEY `x_group_users_FK_user_id` (`user_id`),
+  KEY `x_group_users_cr_time` (`create_time`),
+  KEY `x_group_users_up_time` (`update_time`),
+  CONSTRAINT `x_group_users_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_group_users_FK_p_group_id` FOREIGN KEY (`p_group_id`) REFERENCES `x_group` (`id`),
+  CONSTRAINT `x_group_users_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_group_users_FK_user_id` FOREIGN KEY (`user_id`) REFERENCES `x_user` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `x_group_users`
+--
+
+LOCK TABLES `x_group_users` WRITE;
+/*!40000 ALTER TABLE `x_group_users` DISABLE KEYS */;
+/*!40000 ALTER TABLE `x_group_users` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `x_perm_map`
+--
+
+DROP TABLE IF EXISTS `x_perm_map`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `x_perm_map` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `create_time` datetime DEFAULT NULL,
+  `update_time` datetime DEFAULT NULL,
+  `added_by_id` bigint(20) DEFAULT NULL,
+  `upd_by_id` bigint(20) DEFAULT NULL,
+  `perm_group` varchar(1024) DEFAULT NULL,
+  `res_id` bigint(20) DEFAULT NULL,
+  `group_id` bigint(20) DEFAULT NULL,
+  `user_id` bigint(20) DEFAULT NULL,
+  `perm_for` int(11) NOT NULL DEFAULT '0',
+  `perm_type` int(11) NOT NULL DEFAULT '0',
+  `is_recursive` int(11) NOT NULL DEFAULT '0',
+  `is_wild_card` tinyint(1) NOT NULL DEFAULT '1',
+  `grant_revoke` tinyint(1) NOT NULL DEFAULT '1',
+  `ip_address` text,
+  PRIMARY KEY (`id`),
+  KEY `x_perm_map_FK_added_by_id` (`added_by_id`),
+  KEY `x_perm_map_FK_upd_by_id` (`upd_by_id`),
+  KEY `x_perm_map_FK_res_id` (`res_id`),
+  KEY `x_perm_map_FK_group_id` (`group_id`),
+  KEY `x_perm_map_FK_user_id` (`user_id`),
+  KEY `x_perm_map_cr_time` (`create_time`),
+  KEY `x_perm_map_up_time` (`update_time`),
+  CONSTRAINT `x_perm_map_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_perm_map_FK_group_id` FOREIGN KEY (`group_id`) REFERENCES `x_group` (`id`),
+  CONSTRAINT `x_perm_map_FK_res_id` FOREIGN KEY (`res_id`) REFERENCES `x_resource` (`id`),
+  CONSTRAINT `x_perm_map_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_perm_map_FK_user_id` FOREIGN KEY (`user_id`) REFERENCES `x_user` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `x_perm_map`
+--
+
+LOCK TABLES `x_perm_map` WRITE;
+/*!40000 ALTER TABLE `x_perm_map` DISABLE KEYS */;
+/*!40000 ALTER TABLE `x_perm_map` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `x_policy_export_audit`
+--
+
+DROP TABLE IF EXISTS `x_policy_export_audit`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `x_policy_export_audit` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `create_time` datetime DEFAULT NULL,
+  `update_time` datetime DEFAULT NULL,
+  `added_by_id` bigint(20) DEFAULT NULL,
+  `upd_by_id` bigint(20) DEFAULT NULL,
+  `client_ip` varchar(255) NOT NULL,
+  `agent_id` varchar(255) DEFAULT NULL,
+  `req_epoch` bigint(20) NOT NULL,
+  `last_updated` datetime DEFAULT NULL,
+  `repository_name` varchar(1024) DEFAULT NULL,
+  `exported_json` text,
+  `http_ret_code` int(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`),
+  KEY `x_policy_export_audit_FK_added_by_id` (`added_by_id`),
+  KEY `x_policy_export_audit_FK_upd_by_id` (`upd_by_id`),
+  KEY `x_policy_export_audit_cr_time` (`create_time`),
+  KEY `x_policy_export_audit_up_time` (`update_time`),
+  CONSTRAINT `x_policy_export_audit_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_policy_export_audit_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `x_policy_export_audit`
+--
+
+LOCK TABLES `x_policy_export_audit` WRITE;
+/*!40000 ALTER TABLE `x_policy_export_audit` DISABLE KEYS */;
+/*!40000 ALTER TABLE `x_policy_export_audit` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `x_portal_user`
+--
+
+DROP TABLE IF EXISTS `x_portal_user`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `x_portal_user` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `create_time` datetime DEFAULT NULL,
+  `update_time` datetime DEFAULT NULL,
+  `added_by_id` bigint(20) DEFAULT NULL,
+  `upd_by_id` bigint(20) DEFAULT NULL,
+  `first_name` varchar(1022) DEFAULT NULL,
+  `last_name` varchar(1022) DEFAULT NULL,
+  `pub_scr_name` varchar(2048) DEFAULT NULL,
+  `login_id` varchar(767) DEFAULT NULL,
+  `password` varchar(512) NOT NULL,
+  `email` varchar(512) DEFAULT NULL,
+  `status` int(11) NOT NULL DEFAULT '0',
+  `user_src` int(11) NOT NULL DEFAULT '0',
+  `notes` varchar(4000) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `x_portal_user_UK_login_id` (`login_id`),
+  UNIQUE KEY `x_portal_user_UK_email` (`email`),
+  KEY `x_portal_user_FK_added_by_id` (`added_by_id`),
+  KEY `x_portal_user_FK_upd_by_id` (`upd_by_id`),
+  KEY `x_portal_user_cr_time` (`create_time`),
+  KEY `x_portal_user_up_time` (`update_time`),
+  KEY `x_portal_user_name` (`first_name`(767)),
+  KEY `x_portal_user_email` (`email`),
+  CONSTRAINT `x_portal_user_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_portal_user_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `x_portal_user`
+--
+
+LOCK TABLES `x_portal_user` WRITE;
+/*!40000 ALTER TABLE `x_portal_user` DISABLE KEYS */;
+INSERT INTO `x_portal_user` VALUES (1,'2014-05-25 00:07:26','2014-05-25 00:07:26',NULL,NULL,'Admin','','Admin','admin','ceb4f32325eda6142bd65215f4c0f371','',1,0,NULL);
+/*!40000 ALTER TABLE `x_portal_user` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `x_portal_user_role`
+--
+
+DROP TABLE IF EXISTS `x_portal_user_role`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `x_portal_user_role` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `create_time` datetime DEFAULT NULL,
+  `update_time` datetime DEFAULT NULL,
+  `added_by_id` bigint(20) DEFAULT NULL,
+  `upd_by_id` bigint(20) DEFAULT NULL,
+  `user_id` bigint(20) NOT NULL,
+  `user_role` varchar(128) DEFAULT NULL,
+  `status` int(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`),
+  KEY `x_portal_user_role_FK_added_by_id` (`added_by_id`),
+  KEY `x_portal_user_role_FK_upd_by_id` (`upd_by_id`),
+  KEY `x_portal_user_role_FK_user_id` (`user_id`),
+  KEY `x_portal_user_role_cr_time` (`create_time`),
+  KEY `x_portal_user_role_up_time` (`update_time`),
+  CONSTRAINT `x_portal_user_role_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_portal_user_role_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_portal_user_role_FK_user_id` FOREIGN KEY (`user_id`) REFERENCES `x_portal_user` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `x_portal_user_role`
+--
+
+LOCK TABLES `x_portal_user_role` WRITE;
+/*!40000 ALTER TABLE `x_portal_user_role` DISABLE KEYS */;
+INSERT INTO `x_portal_user_role` VALUES (1,'2014-05-25 00:07:26','2014-05-25 00:07:26',NULL,NULL,1,'ROLE_SYS_ADMIN',1);
+/*!40000 ALTER TABLE `x_portal_user_role` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `x_resource`
+--
+
+DROP TABLE IF EXISTS `x_resource`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `x_resource` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `create_time` datetime DEFAULT NULL,
+  `update_time` datetime DEFAULT NULL,
+  `added_by_id` bigint(20) DEFAULT NULL,
+  `upd_by_id` bigint(20) DEFAULT NULL,
+  `res_name` varchar(4000) DEFAULT NULL,
+  `policy_name` varchar(500)  DEFAULT NULL,
+  `descr` varchar(4000) DEFAULT NULL,
+  `res_type` int(11) NOT NULL DEFAULT '0',
+  `asset_id` bigint(20) NOT NULL,
+  `parent_id` bigint(20) DEFAULT NULL,
+  `parent_path` varchar(4000) DEFAULT NULL,
+  `is_encrypt` int(11) NOT NULL DEFAULT '0',
+  `is_recursive` int(11) NOT NULL DEFAULT '0',
+  `res_group` varchar(1024) DEFAULT NULL,
+  `res_dbs` text,
+  `res_tables` text,
+  `res_col_fams` text,
+  `res_cols` text,
+  `res_udfs` text,
+  `res_status` int(11) NOT NULL DEFAULT '1',
+  `table_type` int(11) NOT NULL DEFAULT '0',
+  `col_type` int(11) NOT NULL DEFAULT '0',
+  `res_topologies` text,
+  `res_services` text,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `policy_name` (`policy_name`),
+  KEY `x_resource_FK_added_by_id` (`added_by_id`),
+  KEY `x_resource_FK_upd_by_id` (`upd_by_id`),
+  KEY `x_resource_FK_asset_id` (`asset_id`),
+  KEY `x_resource_FK_parent_id` (`parent_id`),
+  KEY `x_resource_cr_time` (`create_time`),
+  KEY `x_resource_up_time` (`update_time`),
+  CONSTRAINT `x_resource_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_resource_FK_asset_id` FOREIGN KEY (`asset_id`) REFERENCES `x_asset` (`id`),
+  CONSTRAINT `x_resource_FK_parent_id` FOREIGN KEY (`parent_id`) REFERENCES `x_resource` (`id`),
+  CONSTRAINT `x_resource_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `x_resource`
+--
+
+LOCK TABLES `x_resource` WRITE;
+/*!40000 ALTER TABLE `x_resource` DISABLE KEYS */;
+/*!40000 ALTER TABLE `x_resource` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `x_trx_log`
+--
+
+DROP TABLE IF EXISTS `x_trx_log`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `x_trx_log` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `create_time` datetime DEFAULT NULL,
+  `update_time` datetime DEFAULT NULL,
+  `added_by_id` bigint(20) DEFAULT NULL,
+  `upd_by_id` bigint(20) DEFAULT NULL,
+  `class_type` int(11) NOT NULL DEFAULT '0',
+  `object_id` bigint(20) DEFAULT NULL,
+  `parent_object_id` bigint(20) DEFAULT NULL,
+  `parent_object_class_type` int(11) NOT NULL DEFAULT '0',
+  `parent_object_name` varchar(1024) DEFAULT NULL,
+  `object_name` varchar(1024) DEFAULT NULL,
+  `attr_name` varchar(255) DEFAULT NULL,
+  `prev_val` varchar(1024) DEFAULT NULL,
+  `new_val` varchar(1024) DEFAULT NULL,
+  `trx_id` varchar(1024) DEFAULT NULL,
+  `action` varchar(255) DEFAULT NULL,
+  `sess_id` varchar(512) DEFAULT NULL,
+  `req_id` varchar(30) DEFAULT NULL,
+  `sess_type` varchar(30) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `x_trx_log_FK_added_by_id` (`added_by_id`),
+  KEY `x_trx_log_FK_upd_by_id` (`upd_by_id`),
+  KEY `x_trx_log_cr_time` (`create_time`),
+  KEY `x_trx_log_up_time` (`update_time`),
+  CONSTRAINT `x_trx_log_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_trx_log_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `x_trx_log`
+--
+
+LOCK TABLES `x_trx_log` WRITE;
+/*!40000 ALTER TABLE `x_trx_log` DISABLE KEYS */;
+/*!40000 ALTER TABLE `x_trx_log` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `x_user`
+--
+
+DROP TABLE IF EXISTS `x_user`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `x_user` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `create_time` datetime DEFAULT NULL,
+  `update_time` datetime DEFAULT NULL,
+  `added_by_id` bigint(20) DEFAULT NULL,
+  `upd_by_id` bigint(20) DEFAULT NULL,
+  `user_name` varchar(1024) NOT NULL,
+  `descr` varchar(4000) NOT NULL,
+  `status` int(11) NOT NULL DEFAULT '0',
+  `cred_store_id` bigint(20) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `x_user_FK_added_by_id` (`added_by_id`),
+  KEY `x_user_FK_upd_by_id` (`upd_by_id`),
+  KEY `x_user_FK_cred_store_id` (`cred_store_id`),
+  KEY `x_user_cr_time` (`create_time`),
+  KEY `x_user_up_time` (`update_time`),
+  CONSTRAINT `x_user_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `x_user_FK_cred_store_id` FOREIGN KEY (`cred_store_id`) REFERENCES `x_cred_store` (`id`),
+  CONSTRAINT `x_user_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `x_user`
+--
+
+LOCK TABLES `x_user` WRITE;
+/*!40000 ALTER TABLE `x_user` DISABLE KEYS */;
+/*!40000 ALTER TABLE `x_user` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `xa_access_audit`
+--
+
+DROP TABLE IF EXISTS `xa_access_audit`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `xa_access_audit` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `create_time` datetime DEFAULT NULL,
+  `update_time` datetime DEFAULT NULL,
+  `added_by_id` bigint(20) DEFAULT NULL,
+  `upd_by_id` bigint(20) DEFAULT NULL,
+  `audit_type` int(11) NOT NULL DEFAULT '0',
+  `access_result` int(11) DEFAULT '0',
+  `access_type` varchar(255) DEFAULT NULL,
+  `acl_enforcer` varchar(255) DEFAULT NULL,
+  `agent_id` varchar(255) DEFAULT NULL,
+  `client_ip` varchar(255) DEFAULT NULL,
+  `client_type` varchar(255) DEFAULT NULL,
+  `policy_id` bigint(20) DEFAULT '0',
+  `repo_name` varchar(255) DEFAULT NULL,
+  `repo_type` int(11) DEFAULT '0',
+  `result_reason` varchar(255) DEFAULT NULL,
+  `session_id` varchar(255) DEFAULT NULL,
+  `event_time` datetime DEFAULT NULL,
+  `request_user` varchar(255) DEFAULT NULL,
+  `action` varchar(2000) DEFAULT NULL,
+  `request_data` varchar(2000) DEFAULT NULL,
+  `resource_path` varchar(2000) DEFAULT NULL,
+  `resource_type` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `xa_access_audit_FK_added_by_id` (`added_by_id`),
+  KEY `xa_access_audit_FK_upd_by_id` (`upd_by_id`),
+  KEY `xa_access_audit_cr_time` (`create_time`),
+  KEY `xa_access_audit_up_time` (`update_time`),
+  CONSTRAINT `xa_access_audit_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
+  CONSTRAINT `xa_access_audit_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `xa_access_audit`
+--
+
+LOCK TABLES `xa_access_audit` WRITE;
+/*!40000 ALTER TABLE `xa_access_audit` DISABLE KEYS */;
+/*!40000 ALTER TABLE `xa_access_audit` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Current Database: `xa_db`
+--
+
+USE `xa_db`;
+
+--
+-- Final view structure for view `vx_trx_log`
+--
+
+/*!50001 DROP TABLE IF EXISTS `vx_trx_log`*/;
+/*!50001 DROP VIEW IF EXISTS `vx_trx_log`*/;
+/*!50001 SET @saved_cs_client          = @@character_set_client */;
+/*!50001 SET @saved_cs_results         = @@character_set_results */;
+/*!50001 SET @saved_col_connection     = @@collation_connection */;
+/*!50001 SET character_set_client      = latin1 */;
+/*!50001 SET character_set_results     = latin1 */;
+/*!50001 SET collation_connection      = latin1_swedish_ci */;
+/*!50001 CREATE ALGORITHM=UNDEFINED */
+/*!50013 DEFINER=`xaadmin`@`localhost` SQL SECURITY DEFINER */
+/*!50001 VIEW `vx_trx_log` AS select `x_trx_log`.`id` AS `id`,`x_trx_log`.`create_time` AS `create_time`,`x_trx_log`.`update_time` AS `update_time`,`x_trx_log`.`added_by_id` AS `added_by_id`,`x_trx_log`.`upd_by_id` AS `upd_by_id`,`x_trx_log`.`class_type` AS `class_type`,`x_trx_log`.`object_id` AS `object_id`,`x_trx_log`.`parent_object_id` AS `parent_object_id`,`x_trx_log`.`parent_object_class_type` AS `parent_object_class_type`,`x_trx_log`.`attr_name` AS `attr_name`,`x_trx_log`.`parent_object_name` AS `parent_object_name`,`x_trx_log`.`object_name` AS `object_name`,`x_trx_log`.`prev_val` AS `prev_val`,`x_trx_log`.`new_val` AS `new_val`,`x_trx_log`.`trx_id` AS `trx_id`,`x_trx_log`.`action` AS `action`,`x_trx_log`.`sess_id` AS `sess_id`,`x_trx_log`.`req_id` AS `req_id`,`x_trx_log`.`sess_type` AS `sess_type` from `x_trx_log` group by `x_trx_log`.`trx_id` */;
+/*!50001 SET character_set_client      = @saved_cs_client */;
+/*!50001 SET character_set_results     = @saved_cs_results */;
+/*!50001 SET collation_connection      = @saved_col_connection */;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+
+-- Dump completed on 2014-05-25  0:07:27

http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/mysql/xa_db_bare.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/mysql/xa_db_bare.sql b/security-admin/db/mysql/xa_db_bare.sql
new file mode 100644
index 0000000..8204f1d
--- /dev/null
+++ b/security-admin/db/mysql/xa_db_bare.sql
@@ -0,0 +1,15 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements.  See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License.  You may obtain a copy of the License at
+--
+--     http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+

http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/oracle/patches/001-groupsource.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/oracle/patches/001-groupsource.sql b/security-admin/db/oracle/patches/001-groupsource.sql
index cda2d15..a6b0a13 100644
--- a/security-admin/db/oracle/patches/001-groupsource.sql
+++ b/security-admin/db/oracle/patches/001-groupsource.sql
@@ -25,5 +25,4 @@ BEGIN
       execute immediate 'ALTER TABLE x_group ADD group_src NUMBER(10) DEFAULT 0 NOT NULL';
       commit;
   end if;
-end;
-/
+end;/
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/oracle/patches/002-policyname.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/oracle/patches/002-policyname.sql b/security-admin/db/oracle/patches/002-policyname.sql
index be20751..4eb71ee 100644
--- a/security-admin/db/oracle/patches/002-policyname.sql
+++ b/security-admin/db/oracle/patches/002-policyname.sql
@@ -25,5 +25,4 @@ BEGIN
       execute immediate 'ALTER TABLE  x_resource ADD CONSTRAINT x_resource_UK_policy_name UNIQUE(policy_name)';
       commit;
   end if;
-end;
-/
+end;/
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/oracle/patches/003-knoxrepo.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/oracle/patches/003-knoxrepo.sql b/security-admin/db/oracle/patches/003-knoxrepo.sql
index 422649c..ee0ce87 100644
--- a/security-admin/db/oracle/patches/003-knoxrepo.sql
+++ b/security-admin/db/oracle/patches/003-knoxrepo.sql
@@ -45,5 +45,4 @@ Select count(*) into v_column_exists
       execute immediate 'ALTER TABLE  x_perm_map ADD  ip_address CLOB DEFAULT NULL NULL';
       commit;
   end if;
-end;
-/
+end;/
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/oracle/patches/006-createdefaultpublicgroup.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/oracle/patches/006-createdefaultpublicgroup.sql b/security-admin/db/oracle/patches/006-createdefaultpublicgroup.sql
index 55c0cd5..dbdd55a 100644
--- a/security-admin/db/oracle/patches/006-createdefaultpublicgroup.sql
+++ b/security-admin/db/oracle/patches/006-createdefaultpublicgroup.sql
@@ -25,5 +25,4 @@ BEGIN
 		commit;
 	end if;
   end if;
-end;
-/
+end;/
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/oracle/patches/009-updated_schema.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/oracle/patches/009-updated_schema.sql b/security-admin/db/oracle/patches/009-updated_schema.sql
new file mode 100644
index 0000000..2101d03
--- /dev/null
+++ b/security-admin/db/oracle/patches/009-updated_schema.sql
@@ -0,0 +1,407 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements.  See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License.  You may obtain a copy of the License at
+--
+--     http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+/
+CREATE SEQUENCE X_SERVICE_DEF_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
+CREATE SEQUENCE X_SERVICE_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
+CREATE SEQUENCE X_POLICY_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
+CREATE SEQUENCE X_SERVICE_CONFIG_DEF_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
+CREATE SEQUENCE X_RESOURCE_DEF_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
+CREATE SEQUENCE X_ACCESS_TYPE_DEF_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
+CREATE SEQUENCE X_ACCESS_TYPE_DEF_GRANTS_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
+CREATE SEQUENCE X_POLICY_CONDITION_DEF_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
+CREATE SEQUENCE X_ENUM_DEF_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
+CREATE SEQUENCE X_ENUM_ELEMENT_DEF_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
+CREATE SEQUENCE X_SERVICE_CONFIG_MAP_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
+CREATE SEQUENCE X_POLICY_RESOURCE_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
+CREATE SEQUENCE X_POLICY_RESOURCE_MAP_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
+CREATE SEQUENCE X_POLICY_ITEM_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
+CREATE SEQUENCE X_POLICY_ITEM_ACCESS_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
+CREATE SEQUENCE X_POLICY_ITEM_CONDITION_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
+CREATE SEQUENCE X_POLICY_ITEM_USER_PERM_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
+CREATE SEQUENCE X_POLICY_ITEM_GROUP_PERM_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
+CREATE SEQUENCE X_DATA_HIST_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
+commit;
+CREATE TABLE x_service_def (
+id NUMBER(20) NOT NULL,
+guid VARCHAR(1024) DEFAULT NULL NULL,
+create_time DATE DEFAULT NULL NULL,
+update_time DATE DEFAULT NULL NULL,
+added_by_id NUMBER(20) DEFAULT NULL NULL,
+upd_by_id NUMBER(20) DEFAULT NULL NULL,
+version NUMBER(20) DEFAULT NULL NULL,
+name VARCHAR(1024) DEFAULT NULL NULL,
+impl_class_name VARCHAR(1024) DEFAULT NULL NULL,
+label VARCHAR(1024) DEFAULT NULL NULL,
+description VARCHAR(1024) DEFAULT NULL NULL,
+rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
+rb_key_description VARCHAR(1024) DEFAULT NULL NULL,
+is_enabled NUMBER(1) DEFAULT '1' NULL,
+PRIMARY KEY (id),
+CONSTRAINT x_service_def_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_service_def_FK_upd_by_id FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id)
+);
+commit;
+CREATE TABLE x_service(
+id NUMBER(20) NOT NULL,
+guid VARCHAR(1024) DEFAULT NULL NULL,
+create_time DATE DEFAULT NULL NULL,
+update_time DATE DEFAULT NULL NULL,
+added_by_id NUMBER(20) DEFAULT NULL NULL,
+upd_by_id NUMBER(20) DEFAULT NULL NULL,
+version NUMBER(20) DEFAULT NULL NULL,
+type NUMBER(20) DEFAULT NULL NULL,
+name varchar(512) DEFAULT NULL NULL,
+policy_version NUMBER(20) DEFAULT NULL NULL,
+policy_update_time DATE DEFAULT NULL NULL,
+description VARCHAR(1024) DEFAULT NULL NULL,
+is_enabled NUMBER(1) DEFAULT '0' NOT NULL,
+primary key (id),
+CONSTRAINT x_service_name UNIQUE (name),
+CONSTRAINT x_service_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_service_FK_upd_by_id FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_service_FK_type FOREIGN KEY (type) REFERENCES x_service_def (id) 
+);
+commit;
+CREATE TABLE x_policy (
+id NUMBER(20) NOT NULL,
+guid VARCHAR(1024) DEFAULT NULL NULL,
+create_time DATE DEFAULT NULL NULL,
+update_time DATE DEFAULT NULL NULL,
+added_by_id NUMBER(20) DEFAULT NULL NULL,
+upd_by_id NUMBER(20) DEFAULT NULL NULL,
+version NUMBER(20) DEFAULT NULL NULL,
+service NUMBER(20) DEFAULT NULL NULL,
+name VARCHAR(512) DEFAULT NULL NULL,
+description VARCHAR(1024) DEFAULT NULL NULL,
+is_enabled NUMBER(1) DEFAULT '0' NOT NULL,
+is_audit_enabled NUMBER(1) DEFAULT '0' NOT NULL,
+primary key (id),
+CONSTRAINT x_policy_name UNIQUE (name),
+CONSTRAINT x_policy_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_policy_FK_upd_by_id FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_policy_FK_service FOREIGN KEY (service) REFERENCES x_service (id) 
+);
+commit;
+CREATE TABLE x_service_config_def (
+id NUMBER(20) NOT NULL,
+guid VARCHAR(1024) DEFAULT NULL NULL,
+create_time DATE DEFAULT NULL NULL,
+update_time DATE DEFAULT NULL NULL,
+added_by_id NUMBER(20) DEFAULT NULL NULL,
+upd_by_id NUMBER(20) DEFAULT NULL NULL,
+def_id NUMBER(20) NOT NULL,
+name VARCHAR(1024) DEFAULT NULL NULL,
+type VARCHAR(1024) DEFAULT NULL NULL,
+sub_type VARCHAR(1024) DEFAULT NULL NULL,
+is_mandatory NUMBER(1) DEFAULT '0' NOT NULL,
+default_value VARCHAR(1024) DEFAULT NULL NULL,
+label VARCHAR(1024) DEFAULT NULL NULL,
+description VARCHAR(1024) DEFAULT NULL NULL,
+rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
+rb_key_decription VARCHAR(1024) DEFAULT NULL NULL,
+sort_order NUMBER(3) DEFAULT '0' NULL,
+primary key (id),
+CONSTRAINT x_service_conf_def_FK_defid FOREIGN KEY (def_id) REFERENCES x_service_def (id),
+CONSTRAINT x_service_conf_def_FK_added_by FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_service_conf_def_FK_upd_by FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id)
+);
+commit;
+CREATE TABLE x_resource_def (
+id NUMBER(20) NOT NULL,
+guid VARCHAR(1024) DEFAULT NULL NULL,
+create_time DATE DEFAULT NULL NULL,
+update_time DATE DEFAULT NULL NULL,
+added_by_id NUMBER(20) DEFAULT NULL NULL,
+upd_by_id NUMBER(20) DEFAULT NULL NULL,
+def_id NUMBER(20) NOT NULL,
+name VARCHAR(1024) DEFAULT NULL NULL,
+type VARCHAR(1024) DEFAULT NULL NULL,
+res_level NUMBER(20) DEFAULT NULL NULL,
+parent NUMBER(20) DEFAULT NULL NULL,
+mandatory NUMBER(1) DEFAULT '0' NOT NULL,
+look_up_supported NUMBER(1) DEFAULT '0' NOT NULL,
+recursive_supported NUMBER(1) DEFAULT '0' NOT NULL,
+excludes_supported NUMBER(1) DEFAULT '0' NOT NULL,
+matcher VARCHAR(1024) DEFAULT NULL NULL,
+matcher_options varchar(1024) DEFAULT NULL NULL,
+label VARCHAR(1024) DEFAULT NULL NULL,
+description VARCHAR(1024) DEFAULT NULL NULL,
+rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
+rb_key_description VARCHAR(1024) DEFAULT NULL NULL,
+sort_order NUMBER(3) DEFAULT '0' NULL,
+primary key (id),
+CONSTRAINT x_resource_def_FK_parent FOREIGN KEY (parent) REFERENCES x_resource_def (id),
+CONSTRAINT x_resource_def_FK_defid FOREIGN KEY (def_id) REFERENCES x_service_def (id),
+CONSTRAINT x_resource_def_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_resource_def_FK_upd_by_id FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id)
+);
+commit;
+CREATE TABLE x_access_type_def (
+id NUMBER(20) NOT NULL,
+guid VARCHAR(1024) DEFAULT NULL NULL,
+create_time DATE DEFAULT NULL NULL,
+update_time DATE DEFAULT NULL NULL,
+added_by_id NUMBER(20) DEFAULT NULL NULL,
+upd_by_id NUMBER(20) DEFAULT NULL NULL,
+def_id NUMBER(20) NOT NULL,
+name VARCHAR(1024) DEFAULT NULL NULL,
+label VARCHAR(1024) DEFAULT NULL NULL,
+rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
+sort_order NUMBER(3) DEFAULT '0' NULL,
+primary key (id),
+CONSTRAINT x_access_type_def_FK_defid FOREIGN KEY (def_id) REFERENCES x_service_def (id),
+CONSTRAINT x_access_type_def_FK_added_by FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_access_type_def_FK_upd_by FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id)
+);
+commit;
+CREATE TABLE x_access_type_def_grants (
+id NUMBER(20) NOT NULL,
+guid VARCHAR(1024) DEFAULT NULL NULL,
+create_time DATE DEFAULT NULL NULL,
+update_time DATE DEFAULT NULL NULL,
+added_by_id NUMBER(20) DEFAULT NULL NULL,
+upd_by_id NUMBER(20) DEFAULT NULL NULL,
+atd_id NUMBER(20) NOT NULL,
+implied_grant VARCHAR(1024) DEFAULT NULL NULL,
+primary key (id),
+CONSTRAINT x_atd_grants_FK_atdid FOREIGN KEY (atd_id) REFERENCES x_access_type_def (id),
+CONSTRAINT x_atd_grants_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_atd_grants_FK_upd_by_id FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id)
+);
+commit;
+CREATE TABLE x_policy_condition_def (
+id NUMBER(20) NOT NULL,
+guid VARCHAR(1024) DEFAULT NULL NULL,
+create_time DATE DEFAULT NULL NULL,
+update_time DATE DEFAULT NULL NULL,
+added_by_id NUMBER(20) DEFAULT NULL NULL,
+upd_by_id NUMBER(20) DEFAULT NULL NULL,
+def_id NUMBER(20) NOT NULL,
+name VARCHAR(1024) DEFAULT NULL NULL,
+evaluator VARCHAR(1024) DEFAULT NULL NULL,
+evaluator_options VARCHAR(1024) DEFAULT NULL NULL,
+label VARCHAR(1024) DEFAULT NULL NULL,
+description VARCHAR(1024) DEFAULT NULL NULL,
+rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
+rb_key_description VARCHAR(1024) DEFAULT NULL NULL,
+sort_order NUMBER(3) DEFAULT '0' NULL,
+primary key (id),
+CONSTRAINT x_policy_cond_def_FK_defid FOREIGN KEY (def_id) REFERENCES x_service_def (id),
+CONSTRAINT x_policy_cond_def_FK_added_by FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_policy_cond_def_FK_upd_by FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id)
+);
+commit;
+CREATE TABLE x_enum_def (
+id NUMBER(20) NOT NULL,
+guid VARCHAR(1024) DEFAULT NULL NULL,
+create_time DATE DEFAULT NULL NULL,
+update_time DATE DEFAULT NULL NULL,
+added_by_id NUMBER(20) DEFAULT NULL NULL,
+upd_by_id NUMBER(20) DEFAULT NULL NULL,
+def_id NUMBER(20) NOT NULL,
+name VARCHAR(1024) DEFAULT NULL NULL,
+default_index NUMBER(20) DEFAULT NULL NULL,
+primary key (id),
+CONSTRAINT x_enum_def_FK_def_id FOREIGN KEY (def_id) REFERENCES x_service_def (id),
+CONSTRAINT x_enum_def_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_enum_def_FK_upd_by_id FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id)
+);
+commit;
+CREATE TABLE x_enum_element_def (
+id NUMBER(20) NOT NULL,
+guid VARCHAR(1024) DEFAULT NULL NULL,
+create_time DATE DEFAULT NULL NULL,
+update_time DATE DEFAULT NULL NULL,
+added_by_id NUMBER(20) DEFAULT NULL NULL,
+upd_by_id NUMBER(20) DEFAULT NULL NULL,
+enum_def_id NUMBER(20) NOT NULL,
+name VARCHAR(1024) DEFAULT NULL NULL,
+label VARCHAR(1024) DEFAULT NULL NULL,
+rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
+sort_order NUMBER(3) DEFAULT '0' NULL,
+primary key (id),
+CONSTRAINT x_enum_element_def_FK_defid FOREIGN KEY (enum_def_id) REFERENCES x_enum_def (id),
+CONSTRAINT x_enum_element_def_FK_added_by FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_enum_element_def_FK_upd_by FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id)
+);
+commit;
+CREATE TABLE x_service_config_map (
+id NUMBER(20) NOT NULL,
+guid VARCHAR(1024) DEFAULT NULL NULL,
+create_time DATE DEFAULT NULL NULL,
+update_time DATE DEFAULT NULL NULL,
+added_by_id NUMBER(20) DEFAULT NULL NULL,
+upd_by_id NUMBER(20) DEFAULT NULL NULL,
+service NUMBER(20) NOT NULL,
+config_key VARCHAR(1024) DEFAULT NULL NULL,
+config_value VARCHAR(1024) DEFAULT NULL NULL,
+primary key (id),
+CONSTRAINT x_service_conf_map_FK_service FOREIGN KEY (service) REFERENCES x_service (id),
+CONSTRAINT x_service_conf_map_FK_added_by FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_service_conf_map_FK_upd_by FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id)
+);
+commit;
+CREATE TABLE x_policy_resource (
+id NUMBER(20) NOT NULL,
+guid VARCHAR(1024) DEFAULT NULL NULL,
+create_time DATE DEFAULT NULL NULL,
+update_time DATE DEFAULT NULL NULL,
+added_by_id NUMBER(20) DEFAULT NULL NULL,
+upd_by_id NUMBER(20) DEFAULT NULL NULL,
+policy_id NUMBER(20) NOT NULL,
+res_def_id NUMBER(20) NOT NULL,
+is_excludes NUMBER(1) DEFAULT '0' NOT NULL,
+is_recursive NUMBER(1) DEFAULT '0' NOT NULL,
+primary key (id),
+CONSTRAINT x_policy_res_FK_policy_id FOREIGN KEY (policy_id) REFERENCES x_policy (id),
+CONSTRAINT x_policy_res_FK_res_def_id FOREIGN KEY (res_def_id) REFERENCES x_resource_def (id),
+CONSTRAINT x_policy_res_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_policy_res_FK_upd_by_id FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id)
+);
+commit;
+CREATE TABLE x_policy_resource_map (
+id NUMBER(20) NOT NULL,
+guid VARCHAR(1024) DEFAULT NULL NULL,
+create_time DATE DEFAULT NULL NULL,
+update_time DATE DEFAULT NULL NULL,
+added_by_id NUMBER(20) DEFAULT NULL NULL,
+upd_by_id NUMBER(20) DEFAULT NULL NULL,
+resource_id NUMBER(20) NOT NULL,
+value VARCHAR(1024) DEFAULT NULL NULL,
+sort_order NUMBER(3) DEFAULT '0' NULL,
+primary key (id),
+CONSTRAINT x_policy_res_map_FK_res_id FOREIGN KEY (resource_id) REFERENCES x_policy_resource (id),
+CONSTRAINT x_policy_res_map_FK_added_by FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_policy_res_map_FK_upd_by FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id)
+);
+commit;
+CREATE TABLE x_policy_item (
+id NUMBER(20) NOT NULL,
+guid VARCHAR(1024) DEFAULT NULL NULL,
+create_time DATE DEFAULT NULL NULL,
+update_time DATE DEFAULT NULL NULL,
+added_by_id NUMBER(20) DEFAULT NULL NULL,
+upd_by_id NUMBER(20) DEFAULT NULL NULL,
+policy_id NUMBER(20) NOT NULL,
+delegate_admin NUMBER(1) DEFAULT '0' NOT NULL,
+sort_order NUMBER(3) DEFAULT '0' NULL,
+primary key (id),
+CONSTRAINT x_policy_item_FK_policy_id FOREIGN KEY (policy_id) REFERENCES x_policy (id),
+CONSTRAINT x_policy_item_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_policy_item_FK_upd_by_id FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id) 
+);
+commit;
+CREATE TABLE x_policy_item_access (
+id NUMBER(20) NOT NULL,
+guid VARCHAR(1024) DEFAULT NULL NULL,
+create_time DATE DEFAULT NULL NULL,
+update_time DATE DEFAULT NULL NULL,
+added_by_id NUMBER(20) DEFAULT NULL NULL,
+upd_by_id NUMBER(20) DEFAULT NULL NULL,
+policy_item_id NUMBER(20) NOT NULL,
+type NUMBER(20) NOT NULL,
+is_allowed NUMBER(3) DEFAULT '0' NOT NULL,
+sort_order NUMBER(3) DEFAULT '0' NULL,
+primary key (id),
+CONSTRAINT x_plc_item_access_FK_pi_id FOREIGN KEY (policy_item_id) REFERENCES x_policy_item (id),
+CONSTRAINT x_plc_item_access_FK_atd_id FOREIGN KEY (type) REFERENCES x_access_type_def (id),
+CONSTRAINT x_plc_item_access_FK_added_by FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_plc_item_access_FK_upd_by FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id)
+);
+commit;
+CREATE TABLE x_policy_item_condition (
+id NUMBER(20) NOT NULL,
+guid VARCHAR(1024) DEFAULT NULL NULL,
+create_time DATE DEFAULT NULL NULL,
+update_time DATE DEFAULT NULL NULL,
+added_by_id NUMBER(20) DEFAULT NULL NULL,
+upd_by_id NUMBER(20) DEFAULT NULL NULL,
+policy_item_id NUMBER(20) NOT NULL,
+type NUMBER(20) NOT NULL,
+value VARCHAR(1024) DEFAULT NULL NULL,
+sort_order NUMBER(3) DEFAULT '0' NULL,
+primary key (id),
+CONSTRAINT x_plc_item_cond_FK_pi_id FOREIGN KEY (policy_item_id) REFERENCES x_policy_item (id),
+CONSTRAINT x_plc_item_cond_FK_pcd_id FOREIGN KEY (type) REFERENCES x_policy_condition_def (id),
+CONSTRAINT x_plc_item_cond_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_plc_item_cond_FK_upd_by_id FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id)
+);
+commit;
+CREATE TABLE x_policy_item_user_perm (
+id NUMBER(20) NOT NULL,
+guid VARCHAR(1024) DEFAULT NULL NULL,
+create_time DATE DEFAULT NULL NULL,
+update_time DATE DEFAULT NULL NULL,
+added_by_id NUMBER(20) DEFAULT NULL NULL,
+upd_by_id NUMBER(20) DEFAULT NULL NULL,
+policy_item_id NUMBER(20) NOT NULL,
+user_id NUMBER(20) DEFAULT NULL NULL,
+sort_order NUMBER(3) DEFAULT '0' NULL,
+primary key (id),
+CONSTRAINT x_plc_itm_usr_perm_FK_pi_id FOREIGN KEY (policy_item_id) REFERENCES x_policy_item (id),
+CONSTRAINT x_plc_itm_usr_perm_FK_user_id FOREIGN KEY (user_id) REFERENCES x_user (id),
+CONSTRAINT x_plc_itm_usr_perm_FK_added_by FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_plc_itm_usr_perm_FK_upd_by FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id)
+);
+commit;
+CREATE TABLE x_policy_item_group_perm (
+id NUMBER(20) NOT NULL,
+guid VARCHAR(1024) DEFAULT NULL NULL,
+create_time DATE DEFAULT NULL NULL,
+update_time DATE DEFAULT NULL NULL,
+added_by_id NUMBER(20) DEFAULT NULL NULL,
+upd_by_id NUMBER(20) DEFAULT NULL NULL,
+policy_item_id NUMBER(20) NOT NULL,
+group_id NUMBER(20) DEFAULT NULL NULL,
+sort_order NUMBER(3) DEFAULT '0' NULL,
+primary key (id),
+CONSTRAINT x_plc_itm_grp_perm_FK_pi_id FOREIGN KEY (policy_item_id) REFERENCES x_policy_item (id),
+CONSTRAINT x_plc_itm_grp_perm_FK_group_id FOREIGN KEY (group_id) REFERENCES x_group (id),
+CONSTRAINT x_plc_itm_grp_perm_FK_added_by FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id),
+CONSTRAINT x_plc_itm_grp_perm_FK_upd_by FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id)
+);
+commit;
+CREATE TABLE x_data_hist (
+id NUMBER(20) NOT NULL,
+create_time DATE DEFAULT NULL NULL,
+update_time DATE DEFAULT NULL NULL,
+obj_guid VARCHAR(1024) NOT NULL,
+obj_class_type NUMBER(11) NOT NULL,
+obj_id NUMBER(20) NOT NULL,
+obj_name VARCHAR(1024) NOT NULL,
+version NUMBER(20) DEFAULT NULL NULL,
+action VARCHAR(512)NOT NULL,
+from_time DATE NOT NULL,
+to_time DATE DEFAULT NULL NULL,
+content CLOB NOT NULL,
+primary key (id)
+);
+commit;
+CREATE INDEX x_service_def_added_by_id ON x_service_def(added_by_id);
+CREATE INDEX x_service_def_upd_by_id ON x_service_def(upd_by_id);
+CREATE INDEX x_service_def_cr_time ON x_service_def(create_time);
+CREATE INDEX x_service_def_up_time ON x_service_def(update_time);
+CREATE INDEX x_service_added_by_id ON x_service(added_by_id);
+CREATE INDEX x_service_upd_by_id ON x_service(upd_by_id);
+CREATE INDEX x_service_cr_time ON x_service(create_time);
+CREATE INDEX x_service_up_time ON x_service(update_time);
+CREATE INDEX x_service_type ON x_service(type);
+CREATE INDEX x_policy_added_by_id ON x_policy(added_by_id);
+CREATE INDEX x_policy_upd_by_id ON x_policy(upd_by_id);
+CREATE INDEX x_policy_cr_time ON x_policy(create_time);
+CREATE INDEX x_policy_up_time ON x_policy(update_time);
+CREATE INDEX x_policy_service ON x_policy(service);
+CREATE INDEX x_resource_def_parent ON x_resource_def(parent);
+commit;
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/oracle/reset_audit_db_oracle.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/oracle/reset_audit_db_oracle.sql b/security-admin/db/oracle/reset_audit_db_oracle.sql
new file mode 100644
index 0000000..8ec832b
--- /dev/null
+++ b/security-admin/db/oracle/reset_audit_db_oracle.sql
@@ -0,0 +1,71 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements.  See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License.  You may obtain a copy of the License at
+--
+--     http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
+CREATE OR REPLACE PROCEDURE sp_dropobject(ObjName IN varchar2,ObjType IN varchar2)
+IS
+v_counter integer;
+BEGIN
+if (ObjType = 'TABLE') then
+    select count(*) into v_counter from user_tables where table_name = upper(ObjName);
+    if (v_counter > 0) then
+      execute immediate 'drop table ' || ObjName || ' cascade constraints';
+    end if;
+end if;
+  if (ObjType = 'PROCEDURE') then
+    select count(*) into v_counter from User_Objects where object_type = 'PROCEDURE' and OBJECT_NAME = upper(ObjName);
+      if (v_counter > 0) then
+        execute immediate 'DROP PROCEDURE ' || ObjName;
+      end if;
+  end if;
+  if (ObjType = 'FUNCTION') then
+    select count(*) into v_counter from User_Objects where object_type = 'FUNCTION' and OBJECT_NAME = upper(ObjName);
+      if (v_counter > 0) then
+        execute immediate 'DROP FUNCTION ' || ObjName;
+      end if;
+  end if;
+  if (ObjType = 'TRIGGER') then
+    select count(*) into v_counter from User_Triggers where TRIGGER_NAME = upper(ObjName);
+      if (v_counter > 0) then
+        execute immediate 'DROP TRIGGER ' || ObjName;
+      end if;
+  end if;
+  if (ObjType = 'VIEW') then
+    select count(*) into v_counter from User_Views where VIEW_NAME = upper(ObjName);
+      if (v_counter > 0) then
+        execute immediate 'DROP VIEW ' || ObjName;
+      end if;
+  end if;
+  if (ObjType = 'SEQUENCE') then
+    select count(*) into v_counter from user_sequences where sequence_name = upper(ObjName);
+      if (v_counter > 0) then
+        execute immediate 'DROP SEQUENCE ' || ObjName;
+      end if;
+  end if;
+  if (ObjType = 'INDEX') then
+    select count(*) into v_counter from user_indexes where index_name = upper(ObjName);
+      if (v_counter > 0) then
+        execute immediate 'DROP INDEX ' || ObjName;
+      end if;
+  end if;
+END;
+/
+call sp_dropobject('XA_ACCESS_AUDIT','TABLE');
+call sp_dropobject('XA_ACCESS_AUDIT_SEQ','SEQUENCE');
+call sp_dropobject('xa_access_audit_added_by_id','INDEX');
+call sp_dropobject('xa_access_audit_upd_by_id','INDEX');
+call sp_dropobject('xa_access_audit_cr_time','INDEX');
+call sp_dropobject('xa_access_audit_up_time','INDEX');
+call sp_dropobject('xa_access_audit_event_time','INDEX');
+commit;
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/oracle/reset_core_db_oracle.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/oracle/reset_core_db_oracle.sql b/security-admin/db/oracle/reset_core_db_oracle.sql
new file mode 100644
index 0000000..ce94027
--- /dev/null
+++ b/security-admin/db/oracle/reset_core_db_oracle.sql
@@ -0,0 +1,114 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements.  See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License.  You may obtain a copy of the License at
+--
+--     http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
+-- create or replace procedure
+commit;
+CREATE OR REPLACE PROCEDURE sp_dropobject(ObjName IN varchar2,ObjType IN varchar2)
+IS
+v_counter integer;
+BEGIN
+if (ObjType = 'TABLE') then
+    select count(*) into v_counter from user_tables where table_name = upper(ObjName);
+    if (v_counter > 0) then
+      execute immediate 'drop table ' || ObjName || ' cascade constraints';
+    end if;
+end if;
+  if (ObjType = 'PROCEDURE') then
+    select count(*) into v_counter from User_Objects where object_type = 'PROCEDURE' and OBJECT_NAME = upper(ObjName);
+      if (v_counter > 0) then
+        execute immediate 'DROP PROCEDURE ' || ObjName;
+      end if;
+  end if;
+  if (ObjType = 'FUNCTION') then
+    select count(*) into v_counter from User_Objects where object_type = 'FUNCTION' and OBJECT_NAME = upper(ObjName);
+      if (v_counter > 0) then
+        execute immediate 'DROP FUNCTION ' || ObjName;
+      end if;
+  end if;
+  if (ObjType = 'TRIGGER') then
+    select count(*) into v_counter from User_Triggers where TRIGGER_NAME = upper(ObjName);
+      if (v_counter > 0) then
+        execute immediate 'DROP TRIGGER ' || ObjName;
+      end if;
+  end if;
+  if (ObjType = 'VIEW') then
+    select count(*) into v_counter from User_Views where VIEW_NAME = upper(ObjName);
+      if (v_counter > 0) then
+        execute immediate 'DROP VIEW ' || ObjName;
+      end if;
+  end if;
+  if (ObjType = 'SEQUENCE') then
+    select count(*) into v_counter from user_sequences where sequence_name = upper(ObjName);
+      if (v_counter > 0) then
+        execute immediate 'DROP SEQUENCE ' || ObjName;
+      end if;
+  end if;
+  if (ObjType = 'INDEX') then
+    select count(*) into v_counter from user_indexes where index_name = upper(ObjName);
+      if (v_counter > 0) then
+        execute immediate 'DROP INDEX ' || ObjName;
+      end if;
+  end if;
+  if (ObjType = 'CONSTRAINT') then
+    select count(*) into v_counter from user_constraints where constraint_name = upper(ObjName);
+      if (v_counter > 0) then
+        execute immediate 'DROP CONSTRAINT ' || ObjName;
+      end if;
+  end if;
+END;
+/
+-- sequence
+call sp_dropobject('SEQ_GEN_IDENTITY','SEQUENCE');
+call sp_dropobject('X_ACCESS_AUDIT_SEQ','SEQUENCE');
+call sp_dropobject('X_ASSET_SEQ','SEQUENCE');
+call sp_dropobject('X_AUDIT_MAP_SEQ','SEQUENCE');
+call sp_dropobject('X_AUTH_SESS_SEQ','SEQUENCE');
+call sp_dropobject('X_CRED_STORE_SEQ','SEQUENCE');
+call sp_dropobject('X_DB_BASE_SEQ','SEQUENCE');
+call sp_dropobject('X_GROUP_SEQ','SEQUENCE');
+call sp_dropobject('X_GROUP_GROUPS_SEQ','SEQUENCE');
+call sp_dropobject('X_GROUP_USERS_SEQ','SEQUENCE');
+call sp_dropobject('X_PERM_MAP_SEQ','SEQUENCE');
+call sp_dropobject('X_POLICY_EXPORT_SEQ','SEQUENCE');
+call sp_dropobject('X_PORTAL_USER_SEQ','SEQUENCE');
+call sp_dropobject('X_PORTAL_USER_ROLE_SEQ','SEQUENCE');
+call sp_dropobject('X_RESOURCE_SEQ','SEQUENCE');
+call sp_dropobject('X_TRX_LOG_SEQ','SEQUENCE');
+call sp_dropobject('X_USER_SEQ','SEQUENCE');
+call sp_dropobject('X_DB_VERSION_H_SEQ','SEQUENCE');
+call sp_dropobject('V_TRX_LOG_SEQ','SEQUENCE');
+call sp_dropobject('XA_ACCESS_AUDIT_SEQ','SEQUENCE');
+commit;
+
+-- drop table
+call sp_dropobject('vx_trx_log','VIEW');
+call sp_dropobject('x_perm_map','TABLE');
+call sp_dropobject('x_audit_map','TABLE');
+call sp_dropobject('x_trx_log','TABLE');
+call sp_dropobject('x_resource','TABLE');
+call sp_dropobject('x_policy_export_audit','TABLE');
+call sp_dropobject('x_group_users','TABLE');
+call sp_dropobject('x_user','TABLE');
+call sp_dropobject('x_group_groups','TABLE');
+call sp_dropobject('X_GROUP','TABLE');
+call sp_dropobject('x_db_base','TABLE');
+call sp_dropobject('x_cred_store','TABLE');
+call sp_dropobject('x_auth_sess','TABLE');
+call sp_dropobject('x_asset','TABLE');
+call sp_dropobject('xa_access_audit','TABLE');
+call sp_dropobject('x_portal_user_role','TABLE');
+call sp_dropobject('x_portal_user','TABLE');
+
+commit;
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/oracle/xa_audit_db_oracle.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/oracle/xa_audit_db_oracle.sql b/security-admin/db/oracle/xa_audit_db_oracle.sql
index 4e1a184..3092055 100644
--- a/security-admin/db/oracle/xa_audit_db_oracle.sql
+++ b/security-admin/db/oracle/xa_audit_db_oracle.sql
@@ -13,61 +13,7 @@
 -- See the License for the specific language governing permissions and
 -- limitations under the License.
 
-CREATE OR REPLACE PROCEDURE sp_dropobject(ObjName IN varchar2,ObjType IN varchar2)
-IS
-v_counter integer;
-BEGIN
-if (ObjType = 'TABLE') then
-    select count(*) into v_counter from user_tables where table_name = upper(ObjName);
-    if (v_counter > 0) then
-      execute immediate 'drop table ' || ObjName || ' cascade constraints';
-    end if;
-end if;
-  if (ObjType = 'PROCEDURE') then
-    select count(*) into v_counter from User_Objects where object_type = 'PROCEDURE' and OBJECT_NAME = upper(ObjName);
-      if (v_counter > 0) then
-        execute immediate 'DROP PROCEDURE ' || ObjName;
-      end if;
-  end if;
-  if (ObjType = 'FUNCTION') then
-    select count(*) into v_counter from User_Objects where object_type = 'FUNCTION' and OBJECT_NAME = upper(ObjName);
-      if (v_counter > 0) then
-        execute immediate 'DROP FUNCTION ' || ObjName;
-      end if;
-  end if;
-  if (ObjType = 'TRIGGER') then
-    select count(*) into v_counter from User_Triggers where TRIGGER_NAME = upper(ObjName);
-      if (v_counter > 0) then
-        execute immediate 'DROP TRIGGER ' || ObjName;
-      end if;
-  end if;
-  if (ObjType = 'VIEW') then
-    select count(*) into v_counter from User_Views where VIEW_NAME = upper(ObjName);
-      if (v_counter > 0) then
-        execute immediate 'DROP VIEW ' || ObjName;
-      end if;
-  end if;
-  if (ObjType = 'SEQUENCE') then
-    select count(*) into v_counter from user_sequences where sequence_name = upper(ObjName);
-      if (v_counter > 0) then
-        execute immediate 'DROP SEQUENCE ' || ObjName;
-      end if;
-  end if;
-  if (ObjType = 'INDEX') then
-    select count(*) into v_counter from user_indexes where index_name = upper(ObjName);
-      if (v_counter > 0) then
-        execute immediate 'DROP INDEX ' || ObjName;
-      end if;
-  end if;
-END;
-/
-call sp_dropobject('XA_ACCESS_AUDIT','TABLE');
-call sp_dropobject('XA_ACCESS_AUDIT_SEQ','SEQUENCE');
-call sp_dropobject('xa_access_audit_added_by_id','INDEX');
-call sp_dropobject('xa_access_audit_upd_by_id','INDEX');
-call sp_dropobject('xa_access_audit_cr_time','INDEX');
-call sp_dropobject('xa_access_audit_up_time','INDEX');
-call sp_dropobject('xa_access_audit_event_time','INDEX');
+
 CREATE SEQUENCE XA_ACCESS_AUDIT_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
 CREATE TABLE xa_access_audit (
 	id NUMBER(20) NOT NULL,

http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/oracle/xa_core_db_oracle.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/oracle/xa_core_db_oracle.sql b/security-admin/db/oracle/xa_core_db_oracle.sql
index 449c461..9cc22ff 100644
--- a/security-admin/db/oracle/xa_core_db_oracle.sql
+++ b/security-admin/db/oracle/xa_core_db_oracle.sql
@@ -13,106 +13,7 @@
 -- See the License for the specific language governing permissions and
 -- limitations under the License.
 
-/* create or replace procedure */
-commit;
-CREATE OR REPLACE PROCEDURE sp_dropobject(ObjName IN varchar2,ObjType IN varchar2)
-IS
-v_counter integer;
-BEGIN
-if (ObjType = 'TABLE') then
-    select count(*) into v_counter from user_tables where table_name = upper(ObjName);
-    if (v_counter > 0) then
-      execute immediate 'drop table ' || ObjName || ' cascade constraints';
-    end if;
-end if;
-  if (ObjType = 'PROCEDURE') then
-    select count(*) into v_counter from User_Objects where object_type = 'PROCEDURE' and OBJECT_NAME = upper(ObjName);
-      if (v_counter > 0) then
-        execute immediate 'DROP PROCEDURE ' || ObjName;
-      end if;
-  end if;
-  if (ObjType = 'FUNCTION') then
-    select count(*) into v_counter from User_Objects where object_type = 'FUNCTION' and OBJECT_NAME = upper(ObjName);
-      if (v_counter > 0) then
-        execute immediate 'DROP FUNCTION ' || ObjName;
-      end if;
-  end if;
-  if (ObjType = 'TRIGGER') then
-    select count(*) into v_counter from User_Triggers where TRIGGER_NAME = upper(ObjName);
-      if (v_counter > 0) then
-        execute immediate 'DROP TRIGGER ' || ObjName;
-      end if;
-  end if;
-  if (ObjType = 'VIEW') then
-    select count(*) into v_counter from User_Views where VIEW_NAME = upper(ObjName);
-      if (v_counter > 0) then
-        execute immediate 'DROP VIEW ' || ObjName;
-      end if;
-  end if;
-  if (ObjType = 'SEQUENCE') then
-    select count(*) into v_counter from user_sequences where sequence_name = upper(ObjName);
-      if (v_counter > 0) then
-        execute immediate 'DROP SEQUENCE ' || ObjName;
-      end if;
-  end if;
-  if (ObjType = 'INDEX') then
-    select count(*) into v_counter from user_indexes where index_name = upper(ObjName);
-      if (v_counter > 0) then
-        execute immediate 'DROP INDEX ' || ObjName;
-      end if;
-  end if;
-  if (ObjType = 'CONSTRAINT') then
-    select count(*) into v_counter from user_constraints where constraint_name = upper(ObjName);
-      if (v_counter > 0) then
-        execute immediate 'DROP CONSTRAINT ' || ObjName;
-      end if;
-  end if;
-END;
-/
-/* sequence */
-call sp_dropobject('SEQ_GEN_IDENTITY','SEQUENCE');
-call sp_dropobject('X_ACCESS_AUDIT_SEQ','SEQUENCE');
-call sp_dropobject('X_ASSET_SEQ','SEQUENCE');
-call sp_dropobject('X_AUDIT_MAP_SEQ','SEQUENCE');
-call sp_dropobject('X_AUTH_SESS_SEQ','SEQUENCE');
-call sp_dropobject('X_CRED_STORE_SEQ','SEQUENCE');
-call sp_dropobject('X_DB_BASE_SEQ','SEQUENCE');
-call sp_dropobject('X_GROUP_SEQ','SEQUENCE');
-call sp_dropobject('X_GROUP_GROUPS_SEQ','SEQUENCE');
-call sp_dropobject('X_GROUP_USERS_SEQ','SEQUENCE');
-call sp_dropobject('X_PERM_MAP_SEQ','SEQUENCE');
-call sp_dropobject('X_POLICY_EXPORT_SEQ','SEQUENCE');
-call sp_dropobject('X_PORTAL_USER_SEQ','SEQUENCE');
-call sp_dropobject('X_PORTAL_USER_ROLE_SEQ','SEQUENCE');
-call sp_dropobject('X_RESOURCE_SEQ','SEQUENCE');
-call sp_dropobject('X_TRX_LOG_SEQ','SEQUENCE');
-call sp_dropobject('X_USER_SEQ','SEQUENCE');
-call sp_dropobject('X_DB_VERSION_H_SEQ','SEQUENCE');
-call sp_dropobject('V_TRX_LOG_SEQ','SEQUENCE');
-call sp_dropobject('XA_ACCESS_AUDIT_SEQ','SEQUENCE');
-commit;
-
-/* drop table */
-call sp_dropobject('vx_trx_log','VIEW');
-call sp_dropobject('x_perm_map','TABLE');
-call sp_dropobject('x_audit_map','TABLE');
-call sp_dropobject('x_trx_log','TABLE');
-call sp_dropobject('x_resource','TABLE');
-call sp_dropobject('x_policy_export_audit','TABLE');
-call sp_dropobject('x_group_users','TABLE');
-call sp_dropobject('x_user','TABLE');
-call sp_dropobject('x_group_groups','TABLE');
-call sp_dropobject('X_GROUP','TABLE');
-call sp_dropobject('x_db_base','TABLE');
-call sp_dropobject('x_cred_store','TABLE');
-call sp_dropobject('x_auth_sess','TABLE');
-call sp_dropobject('x_asset','TABLE');
-call sp_dropobject('xa_access_audit','TABLE');
-call sp_dropobject('x_portal_user_role','TABLE');
-call sp_dropobject('x_portal_user','TABLE');
-
-commit;
-/* create sequences */
+-- create sequences
 CREATE SEQUENCE SEQ_GEN_IDENTITY START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
 CREATE SEQUENCE X_ACCESS_AUDIT_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
 CREATE SEQUENCE X_ASSET_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
@@ -136,7 +37,7 @@ CREATE SEQUENCE XA_ACCESS_AUDIT_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
 commit;
 
 
-/* create tables */
+-- create tables
 CREATE TABLE x_portal_user (
 	id NUMBER(20) NOT NULL,
 	create_time DATE DEFAULT NULL NULL ,
@@ -531,7 +432,7 @@ CREATE INDEX x_user_up_time ON  x_user(update_time);
 
 CREATE OR REPLACE PUBLIC SYNONYM xa_access_audit FOR xa_access_audit;
 CREATE OR REPLACE PUBLIC SYNONYM XA_ACCESS_AUDIT_SEQ FOR XA_ACCESS_AUDIT_SEQ;
-
+commit;
 insert into x_portal_user (
        id,CREATE_TIME, UPDATE_TIME,
        FIRST_NAME, LAST_NAME, PUB_SCR_NAME,
@@ -541,7 +442,7 @@ X_PORTAL_USER_SEQ.NEXTVAL, SYSDATE, SYSDATE,
  'Admin', '', 'Admin',
  'admin', 'ceb4f32325eda6142bd65215f4c0f371', '', 1
 );
-
+commit;
 insert into x_portal_user_role (
       id, CREATE_TIME, UPDATE_TIME,
        USER_ID, USER_ROLE, STATUS
@@ -549,32 +450,9 @@ insert into x_portal_user_role (
 X_PORTAL_USER_ROLE_SEQ.NEXTVAL, SYSDATE, SYSDATE,
  1, 'ROLE_SYS_ADMIN', 1
 );
-
+commit;
 insert into x_user (id,CREATE_TIME, UPDATE_TIME,user_name, status,descr) values (
 X_USER_SEQ.NEXTVAL, SYSDATE, SYSDATE,'admin', 0,'Administrator');
-
-INSERT INTO x_group (ID,ADDED_BY_ID, CREATE_TIME, DESCR, GROUP_TYPE, GROUP_NAME, STATUS, UPDATE_TIME, UPD_BY_ID) VALUES (X_GROUP_SEQ.nextval,1, sys_extract_utc(systimestamp), 'public group', 0, 'public', 0, sys_extract_utc(systimestamp), 1);
-commit;
-
-
-
-CREATE OR REPLACE TRIGGER x_auth_sess_trigger
-  BEFORE INSERT
-  ON x_auth_sess
-  FOR EACH ROW
-  -- Optionally restrict this trigger to fire only when really needed
-  WHEN (new.id is null)
-DECLARE
-  v_id x_auth_sess.id%TYPE;
-BEGIN
-  -- Select a new value from the sequence into a local variable. As
-  -- commented, this step is optional. You can directly select into :new.qname_id
-  SELECT  x_auth_sess_seq.nextval INTO v_id FROM DUAL;
-
-  -- :new references the record that you are about to insert into qname. Hence,
-  -- you can overwrite the value of :new.qname_id (qname.qname_id) with the value
-  -- obtained from your sequence, before inserting
-  :new.id := v_id;
-END my_trigger;
-/
 commit;
+INSERT INTO x_group (ID,ADDED_BY_ID, CREATE_TIME, DESCR, GROUP_TYPE, GROUP_NAME, STATUS, UPDATE_TIME, UPD_BY_ID) VALUES (X_GROUP_SEQ.nextval,1, sys_extract_utc(systimestamp), 'public group', 0, 'public', 0, sys_extract_utc(systimestamp), 1);
+commit;
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/patches/001-groupsource.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/patches/001-groupsource.sql b/security-admin/db/patches/001-groupsource.sql
deleted file mode 100644
index c49d8cb..0000000
--- a/security-admin/db/patches/001-groupsource.sql
+++ /dev/null
@@ -1,34 +0,0 @@
--- Licensed to the Apache Software Foundation (ASF) under one or more
--- contributor license agreements.  See the NOTICE file distributed with
--- this work for additional information regarding copyright ownership.
--- The ASF licenses this file to You under the Apache License, Version 2.0
--- (the "License"); you may not use this file except in compliance with
--- the License.  You may obtain a copy of the License at
---
---     http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
-
- drop procedure if exists add_group_source_column_to_x_group_table;
-
-delimiter ;;
- create procedure add_group_source_column_to_x_group_table() begin
-
- /* add group source column if not exist */
- if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_group') then
-	if not exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_group' and column_name = 'group_src') then
-		ALTER TABLE  `x_group` ADD  `group_src` INT NOT NULL DEFAULT 0;
- 	end if;
- end if;
-  
-end;;
-
-delimiter ;
-
- call add_group_source_column_to_x_group_table();
-
- drop procedure if exists add_group_source_column_to_x_group_table;
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/patches/002-policyname.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/patches/002-policyname.sql b/security-admin/db/patches/002-policyname.sql
deleted file mode 100644
index 35927f5..0000000
--- a/security-admin/db/patches/002-policyname.sql
+++ /dev/null
@@ -1,37 +0,0 @@
--- Licensed to the Apache Software Foundation (ASF) under one or more
--- contributor license agreements.  See the NOTICE file distributed with
--- this work for additional information regarding copyright ownership.
--- The ASF licenses this file to You under the Apache License, Version 2.0
--- (the "License"); you may not use this file except in compliance with
--- the License.  You may obtain a copy of the License at
---
---     http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
-
-drop procedure if exists add_policy_name_column_to_x_resource_table;
-
-delimiter ;;
-create procedure add_policy_name_column_to_x_resource_table() begin
-
- /* add policy name column if not exist */
- if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_resource') then
-  	if not exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_resource' and column_name = 'policy_name') then
-  		ALTER TABLE  `x_resource` ADD  `policy_name` VARCHAR( 500 ) NULL DEFAULT NULL;
-  		if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_resource' and column_name = 'policy_name') then
-  			ALTER TABLE  `x_resource` ADD UNIQUE  `x_resource_UK_policy_name` (  `policy_name` );
-  		end if;
- 	end if;
- end if;
-
-  
-end;;
-
-delimiter ;
-call add_policy_name_column_to_x_resource_table();
-
-drop procedure if exists add_policy_name_column_to_x_resource_table;
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/patches/003-knoxrepo.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/patches/003-knoxrepo.sql b/security-admin/db/patches/003-knoxrepo.sql
deleted file mode 100644
index 04c050a..0000000
--- a/security-admin/db/patches/003-knoxrepo.sql
+++ /dev/null
@@ -1,48 +0,0 @@
--- Licensed to the Apache Software Foundation (ASF) under one or more
--- contributor license agreements.  See the NOTICE file distributed with
--- this work for additional information regarding copyright ownership.
--- The ASF licenses this file to You under the Apache License, Version 2.0
--- (the "License"); you may not use this file except in compliance with
--- the License.  You may obtain a copy of the License at
---
---     http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
-
-drop procedure if exists add_columns_for_knox_repository;
-
-delimiter ;;
-create procedure add_columns_for_knox_repository() begin
-
- /* add res_topologies if  not exist */
- if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_resource') then
- 	if not exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_resource' and column_name = 'res_topologies') then
- 		ALTER TABLE  `x_resource` ADD  `res_topologies` TEXT NULL DEFAULT NULL ;
- 	end if;
- end if;
- 
-  /* add res_services if  not exist */
- if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_resource') then
- 	if not exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_resource' and column_name = 'res_services') then
- 		ALTER TABLE  `x_resource` ADD  `res_services` TEXT NULL DEFAULT NULL;
- 	end if;
- end if;
- 
-  /* add ip_address if  not exist */
- if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_perm_map') then
- 	if not exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_perm_map' and column_name = 'ip_address') then
- 		ALTER TABLE  `x_perm_map` ADD  `ip_address` TEXT NULL DEFAULT NULL;
- 	end if;
- end if;
-
-  
-end;;
-
-delimiter ;
-call add_columns_for_knox_repository();
-
-drop procedure if exists add_columns_for_knox_repository;

http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/patches/004-assetconfigsize.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/patches/004-assetconfigsize.sql b/security-admin/db/patches/004-assetconfigsize.sql
deleted file mode 100644
index bec992b..0000000
--- a/security-admin/db/patches/004-assetconfigsize.sql
+++ /dev/null
@@ -1,31 +0,0 @@
--- Licensed to the Apache Software Foundation (ASF) under one or more
--- contributor license agreements.  See the NOTICE file distributed with
--- this work for additional information regarding copyright ownership.
--- The ASF licenses this file to You under the Apache License, Version 2.0
--- (the "License"); you may not use this file except in compliance with
--- the License.  You may obtain a copy of the License at
---
---     http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
-
-drop procedure if exists change_config_column_datatype_of_x_asset_table;
-
-delimiter ;;
-create procedure change_config_column_datatype_of_x_asset_table() begin
-
- /* change config data type to longtext if not exist */
- if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_asset' and column_name = 'config' and data_type='text') then
- 	ALTER TABLE  `x_asset` CHANGE  `config`  `config` MEDIUMTEXT NULL DEFAULT NULL ;
- end if;
-  
-end;;
-
-delimiter ;
-call change_config_column_datatype_of_x_asset_table();
-
-drop procedure if exists change_config_column_datatype_of_x_asset_table;

http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/patches/005-xtrxlogcolumnsize.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/patches/005-xtrxlogcolumnsize.sql b/security-admin/db/patches/005-xtrxlogcolumnsize.sql
deleted file mode 100644
index 4ec9a6d..0000000
--- a/security-admin/db/patches/005-xtrxlogcolumnsize.sql
+++ /dev/null
@@ -1,34 +0,0 @@
--- Licensed to the Apache Software Foundation (ASF) under one or more
--- contributor license agreements.  See the NOTICE file distributed with
--- this work for additional information regarding copyright ownership.
--- The ASF licenses this file to You under the Apache License, Version 2.0
--- (the "License"); you may not use this file except in compliance with
--- the License.  You may obtain a copy of the License at
---
---     http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
-
-drop procedure if exists change_values_columns_datatype_of_x_trx_log_table;
-
-delimiter ;;
-create procedure change_values_columns_datatype_of_x_trx_log_table() begin
-
- /* change prev_value column data type to mediumtext */
- if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_trx_log' and column_name = 'prev_val' and data_type='varchar') then
- 	ALTER TABLE  `x_trx_log` CHANGE  `prev_val`  `prev_val` MEDIUMTEXT NULL DEFAULT NULL ;
- end if;
- if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_trx_log' and column_name = 'new_val'  and data_type='varchar') then
- 	ALTER TABLE  `x_trx_log` CHANGE  `new_val`  `new_val` MEDIUMTEXT NULL DEFAULT NULL ;
- end if;
-  
-end;;
-
-delimiter ;
-call change_values_columns_datatype_of_x_trx_log_table();
-
-drop procedure if exists change_values_columns_datatype_of_x_trx_log_table;

http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/patches/006-createdefaultpublicgroup.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/patches/006-createdefaultpublicgroup.sql b/security-admin/db/patches/006-createdefaultpublicgroup.sql
deleted file mode 100644
index ddb211e..0000000
--- a/security-admin/db/patches/006-createdefaultpublicgroup.sql
+++ /dev/null
@@ -1,34 +0,0 @@
--- Licensed to the Apache Software Foundation (ASF) under one or more
--- contributor license agreements.  See the NOTICE file distributed with
--- this work for additional information regarding copyright ownership.
--- The ASF licenses this file to You under the Apache License, Version 2.0
--- (the "License"); you may not use this file except in compliance with
--- the License.  You may obtain a copy of the License at
---
---     http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
-
-drop procedure if exists insert_public_group_in_x_group_table;
-
-delimiter ;;
-create procedure insert_public_group_in_x_group_table() begin
-
- /* check table x_group exist or not */
- if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_group') then
- 	/* check record for group name public exist or not */
- 	if not exists (select * from x_group where group_name = 'public') then
- 		INSERT INTO x_group (ADDED_BY_ID, CREATE_TIME, DESCR, GROUP_SRC, GROUP_TYPE, GROUP_NAME, STATUS, UPDATE_TIME, UPD_BY_ID) VALUES (1, UTC_TIMESTAMP(), 'public group', 0, 0, 'public', 0, UTC_TIMESTAMP(), 1);
- 	end if;
- end if;
-  
-end;;
-
-delimiter ;
-call insert_public_group_in_x_group_table();
-
-drop procedure if exists insert_public_group_in_x_group_table;


Mime
View raw message