在Hive中，可以使用GRANT語句來為用戶或用戶組分配權限
GRANT [ROLE|USER] ON [DATABASE.]TABLE TO [USER|ROLE] [WITH GRANT OPTION];
參數說明：
示例：
GRANT SELECT ON mydatabase.mytable TO user1;
GRANT INSERT, UPDATE ON mydatabase.mytable TO role1;
GRANT ALL ON mydatabase.mytable TO group1;
GRANT SELECT, INSERT ON mydatabase.mytable TO user2 WITH GRANT OPTION;
GRANT SELECT, INSERT ON mydatabase.mytable TO role2 WITH GRANT OPTION;
注意：在分配權限時，請確保您具有足夠的權限來執行這些操作。
