GRANT and REVOKE

Syntax

GRANT [privilege1] [, [privilege2] … ] ON [table] TO [grantee1] [, [grantee2] … ] [ WITH GRANT OPTION ]
REVOKE [privilege1] [, [privilege2] … ] ON [table] FROM [grantee1] [, [grantee2] … ]

Remarks

Grant permissions to users. If the WITH GRANT OPTION is specified, the grantee additionally gains the privilege to grant the given permission or revoke previously granted permissions.

Found a mistake? Have a question or improvement idea? Let me know.

Table Of Contents