Karan Mehta created PHOENIX-4417:
------------------------------------
Summary: Add a SQL command to view permissions
Key: PHOENIX-4417
URL: https://issues.apache.org/jira/browse/PHOENIX-4417
Project: Phoenix
Issue Type: New Feature
Reporter: Karan Mehta
We have PHOENIX-672. This JIRA is directly related to it.
Add a SQL command {{user_permissions}} to view the current state of permissions
for a user, table, schema. This can help the user determine if the permissions
of various related tables are in-sync or not, when exception is thrown. As of
now, we can only do it via scanning {{hbase:acl}} table.
A quick search shows that traditional SQL DB's don't have special statements
for this, they rather use select queries on acl tables to determine the
permissions. We need to bring up our own syntax in such a case.
If we want to continue with SQL standard, then we need to introduce an
additional case where the select query works on the acl table directly.
HBase:acl table is not exposed via Phoenix, so the change will not be
straightforward. This JIRA is to discuss how we should approach this feature.
Please provide suggestions.
[[email protected]] [~jamestaylor] [[email protected]] [~apurtell]
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
