[HIVE-3047] Add a privilege for cross database access

• Type: Task
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: Authorization
• Assignee: Unassigned
• Reporter: Sambavi Muthukrishnan
• Created: 23/May/12 16:32
• Updated: 02/May/13 02:30

Description

This JIRA is for adding a new privilege for cross database operations.

Privilege will be called something like "cross_database_commands"

GRANT cross_database_commands ON DATABASE db TO USER x;
GRANT cross_database_commands ON DATABASE db to ROLE x;

This privilege would be provided by default, but if absent, then the user would be prevented from referencing DBs outside of 'db' while using 'db' as the primary database.

We will also need a way for this privilege be turned off by default for all users, groups and roles for newly created databases.

Issue Links

• is related to: HIVE-2989 Adding Table Links to Hive