[
https://issues.apache.org/jira/browse/HIVE-3016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13276545#comment-13276545
]
Carl Steinbach commented on HIVE-3016:
--------------------------------------
@Namit: I found this in authorization_5.q in the clientpositive directory:
{noformat}
GRANT drop ON DATABASE test_db TO USER hive_test_user;
GRANT select ON DATABASE test_db TO USER hive_test_user;
SHOW GRANT USER hive_test_user ON DATABASE test_db;
CREATE ROLE db_test_role;
GRANT ROLE db_test_role TO USER hive_test_user;
SHOW ROLE GRANT USER hive_test_user;
GRANT drop ON DATABASE test_db TO ROLE db_test_role;
GRANT select ON DATABASE test_db TO ROLE db_test_role;
SHOW GRANT ROLE db_test_role ON DATABASE test_db;
{noformat}
Looks like this patch duplicates functionality that is already provided by the
authorization system.
> Allow disabling foreign table access (cross database) using hiveconf
> --------------------------------------------------------------------
>
> Key: HIVE-3016
> URL: https://issues.apache.org/jira/browse/HIVE-3016
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor
> Reporter: Sambavi Muthukrishnan
> Assignee: Sambavi Muthukrishnan
> Priority: Minor
> Attachments: hive-3016.1.patch.txt
>
> Original Estimate: 48h
> Remaining Estimate: 48h
>
> Disallow cross database access to tables using Y.T syntax under a specific
> configuration in HiveConf.
> i.e. when hive.error.on.crossdatabaseaccess is set to true, return an error
> when Y.T syntax is used to access tables and Y is not the current database.
> This can be set both via the client and in hive-site.xml, and will default to
> false.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
