svn commit: r1584451 - in /hive/branches/branch-0.13/ql/src/test: queries/clientpositive/authorization_owner_actions_db.q results/clientpositive/authorization_owner_actions_db.q.out

[th...@apache.org]

Author: thejas
Date: Thu Apr  3 22:59:47 2014
New Revision: 1584451

URL: http://svn.apache.org/r1584451
Log:
HIVE-6823 : adding missing files

Added:
    hive/branches/branch-0.13/ql/src/test/queries/clientpositive/authorization_owner_actions_db.q
    hive/branches/branch-0.13/ql/src/test/results/clientpositive/authorization_owner_actions_db.q.out

Added: hive/branches/branch-0.13/ql/src/test/queries/clientpositive/authorization_owner_actions_db.q
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/queries/clientpositive/authorization_owner_actions_db.q?rev=1584451&view=auto
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/queries/clientpositive/authorization_owner_actions_db.q (added)
+++ hive/branches/branch-0.13/ql/src/test/queries/clientpositive/authorization_owner_actions_db.q Thu Apr  3 22:59:47 2014
@@ -0,0 +1,21 @@
+set hive.users.in.admin.role=hive_admin_user;
+set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactory;
+set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator;
+set hive.security.authorization.enabled=true;
+set user.name=hive_admin_user;
+
+set role admin;
+-- create role, db, make role the owner of db
+create role testrole;
+grant role testrole to user hrt_1;
+create database testdb;
+alter database testdb set owner role testrole;
+desc database testdb;
+
+-- actions that require user to be db owner 
+-- create table
+use testdb;
+create table foobar (foo string, bar string);
+
+-- drop db
+drop database testdb cascade;

Added: hive/branches/branch-0.13/ql/src/test/results/clientpositive/authorization_owner_actions_db.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/authorization_owner_actions_db.q.out?rev=1584451&view=auto
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/authorization_owner_actions_db.q.out (added)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/authorization_owner_actions_db.q.out Thu Apr  3 22:59:47 2014
@@ -0,0 +1,55 @@
+PREHOOK: query: set role admin
+PREHOOK: type: SHOW_ROLES
+POSTHOOK: query: set role admin
+POSTHOOK: type: SHOW_ROLES
+#### A masked pattern was here ####
+create role testrole
+PREHOOK: type: CREATEROLE
+#### A masked pattern was here ####
+create role testrole
+POSTHOOK: type: CREATEROLE
+PREHOOK: query: grant role testrole to user hrt_1
+PREHOOK: type: GRANT_ROLE
+POSTHOOK: query: grant role testrole to user hrt_1
+POSTHOOK: type: GRANT_ROLE
+PREHOOK: query: create database testdb
+PREHOOK: type: CREATEDATABASE
+POSTHOOK: query: create database testdb
+POSTHOOK: type: CREATEDATABASE
+#### A masked pattern was here ####
+PREHOOK: type: ALTERDATABASE_OWNER
+PREHOOK: Output: database:testdb
+#### A masked pattern was here ####
+POSTHOOK: type: ALTERDATABASE_OWNER
+POSTHOOK: Output: database:testdb
+PREHOOK: query: desc database testdb
+PREHOOK: type: DESCDATABASE
+POSTHOOK: query: desc database testdb
+POSTHOOK: type: DESCDATABASE
+#### A masked pattern was here ####
+-- create table
+use testdb
+PREHOOK: type: SWITCHDATABASE
+#### A masked pattern was here ####
+-- create table
+use testdb
+POSTHOOK: type: SWITCHDATABASE
+PREHOOK: query: create table foobar (foo string, bar string)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:testdb
+POSTHOOK: query: create table foobar (foo string, bar string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:testdb
+POSTHOOK: Output: testdb@foobar
+PREHOOK: query: -- drop db
+drop database testdb cascade
+PREHOOK: type: DROPDATABASE
+PREHOOK: Input: database:testdb
+PREHOOK: Output: database:testdb
+PREHOOK: Output: testdb@foobar
+POSTHOOK: query: -- drop db
+drop database testdb cascade
+POSTHOOK: type: DROPDATABASE
+POSTHOOK: Input: database:testdb
+POSTHOOK: Output: database:testdb
+POSTHOOK: Output: testdb@foobar