HonglunChen created SENTRY-2525:
-----------------------------------
Summary: 'revoke all on database x from ROLE y' command adds a
record to the table 'SENTRY_DB_PRIVILEGE'
Key: SENTRY-2525
URL: https://issues.apache.org/jira/browse/SENTRY-2525
Project: Sentry
Issue Type: Bug
Components: sentrystore
Affects Versions: 1.7.1
Reporter: HonglunChen
Before the command is executed, there is the following record for the table
'SENTRY_DB_PRIVILEGE'：
DB_PRIVILEGE_ID PRIVILEGE_SCOPE SERVER_NAME DB_NAME TABLE_NAME COLUMN_NAME URI
ACTION CREATE_TIME WITH_GRANT_OPTION
18 DATABASE server1 filtered __NULL__ __NULL__ __NULL__ * 1558435159705 N
After I excute the command 'revoke all on database filtered from ROLE
test_role', the corresponding permissions for test_role were successfully
removed. But there is one more record in table 'SENTRY_DB_PRIVILEGE':
DB_PRIVILEGE_ID PRIVILEGE_SCOPE SERVER_NAME DB_NAME TABLE_NAME COLUMN_NAME URI
ACTION CREATE_TIME WITH_GRANT_OPTION
32 DATABASE server1 filtered __NULL__ __NULL__ __NULL__ * 1560826528884 Y
The only difference is that the 'WITH_GRANT_OPTION' field becomes 'Y'.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
