[jira] [Commented] (SENTRY-855) support DROP ROLE IF EXISTS or CREATE ROLE IF NOT EXISTS

["Mark Grover (JIRA)" <ji...@apache.org>]

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

Mark Grover commented on SENTRY-855:
------------------------------------

I would really love to see these commands being implemented. They are likely not a whole lot of code to add but they are tremendously useful for many use-cases. In particular, for those who run tests, being able create a role only if it doesn't exist or drop a role if exists, is very helpful. Otherwise drop commands fail if the role doesn't exist, and you have us guessing whether that's a legit test failure or not.

> support DROP ROLE IF EXISTS or CREATE ROLE IF NOT EXISTS
> --------------------------------------------------------
>
>                 Key: SENTRY-855
>                 URL: https://issues.apache.org/jira/browse/SENTRY-855
>             Project: Sentry
>          Issue Type: New Feature
>          Components: Service
>    Affects Versions: 1.5.0, 1.5.1
>            Reporter: Anne Yu
>
> For drop database/table/view, we support syntax such as,
> {code}
> DROP DATABASE/TABLE/VIEW [IF EXISTS]
> {code}
> Only for role, there is no support for IF EXISTS,
> We might need to consider to add it.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)