mirror of
https://github.com/hanzo-ds/sqlparser.git
synced 2026-10-30 20:53:50 +00:00
14 lines
608 B
SQL
14 lines
608 B
SQL
GRANT SELECT(x,y) ON db.table TO john;
|
|
GRANT SELECT(x,y) ON db.table TO john WITH GRANT OPTION WITH ADMIN OPTION;
|
|
GRANT SELECT(x,y) ON db.* TO john;
|
|
GRANT SELECT(x,y) ON *.table TO john;
|
|
GRANT SELECT(x,y) ON *.* TO john;
|
|
GRANT SELECT(x,y) ON *.table TO CURRENT_USER;
|
|
GRANT SELECT(x,y) ON *.table TO CURRENT_USER,john,mary;
|
|
GRANT ALL ON *.* TO admin_role WITH GRANT OPTION;
|
|
GRANT SELECT,INSERT ON database.table_1 TO table_1_select_role;
|
|
GRANT SELECT(x, y, z),INSERT ON database.table_1 TO table_1_select_role;
|
|
GRANT SELECT, dictGet ON *.* TO select_all_role;
|
|
GRANT ADMIN OPTION ON *.* TO select_all_role;
|
|
|