mirror of
https://github.com/hanzo-ds/sqlparser.git
synced 2026-10-30 20:53:50 +00:00
30 lines
1.2 KiB
SQL
30 lines
1.2 KiB
SQL
-- Origin 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;
|
|
|
|
|
|
|
|
-- Format 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;
|