[SENTRY-340] Database implement for "with grant option"

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Assignee: Xiaomeng Huang
• Reporter: Xiaomeng Huang
• Created: 17/Jul/14 02:40
• Updated: 04/Aug/14 20:26
• Resolved: 04/Aug/14 20:25

Description

This is database design and implement to support "with grant option".
Add a field grantOption(int) to table SENTRY_DB_PRIVILEGE.
And modify the table SENTRY_DB_PRIVILEGE from a single index

{privilegeName}

to a composite index with member

{privilegeName, grantOption}

Issue Links

• depends upon: SENTRY-339 Remove PrivilegeName column and constructPrivilegeName() function
• Is contained by: SENTRY-327 Support auth admin delegation via SQL construct 'with grant option'
• is depended upon by: SENTRY-343 Privileges query from database support for "With Grant Option"
• is depended upon by: SENTRY-370 Judgement of MSentryPrivilege implies child privileges
• links to: Review Board link