[SENTRY-2525] 'revoke all on database x from ROLE y' command adds a record to the table 'SENTRY_DB_PRIVILEGE'

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.7.1
• Component/s: sentrystore
• Assignee: Unassigned
• Reporter: HonglunChen
• Created: 18/Jun/19 08:48
• Updated: 18/Jun/19 08:48

Description

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'.