[jira] [Created] (PHOENIX-4417) Add a SQL command to view permissions

["Karan Mehta (JIRA)" <ji...@apache.org>]

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.
[~twdsilva@gmail.com] [~jamestaylor] [~ankit@apache.org] [~apurtell]



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)