phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew Purtell (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-672) Add GRANT and REVOKE commands using HBase AccessController
Date Tue, 19 Sep 2017 22:50:00 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-672?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16172469#comment-16172469
] 

Andrew Purtell commented on PHOENIX-672:
----------------------------------------

[~karanmehta93] I prefer we adopt syntax from either Postgres or MySQL. Inventing something
new for Phoenix won't serve anyone especially well. 

Postgres
GRANT: https://www.postgresql.org/docs/8.0/static/sql-grant.html
REVOKE: https://www.postgresql.org/docs/8.0/static/sql-revoke.html

MySQL
GRANT: https://dev.mysql.com/doc/refman/5.7/en/grant.html
REVOKE: https://dev.mysql.com/doc/refman/5.7/en/revoke.html

Adapt one of these with the minimum necessary changes. I like the Postgres syntax better,
FWIW

> Add GRANT and REVOKE commands using HBase AccessController
> ----------------------------------------------------------
>
>                 Key: PHOENIX-672
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-672
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: James Taylor
>            Assignee: Karan Mehta
>              Labels: gsoc2016, security
>
> In HBase 0.98, cell-level security will be available. Take a look at [this](https://communities.intel.com/community/datastack/blog/2013/10/29/hbase-cell-security)
excellent blog post by @apurtell. Once Phoenix works on 0.96, we should add support for security
to our SQL grammar.



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

Mime
View raw message