phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Karan Mehta (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-4417) Add a SQL command to view permissions
Date Thu, 30 Nov 2017 01:05:43 GMT
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)

Mime
View raw message