[
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)
