if we want to assign some privilege to some user say "sonu" then we can assign privilege using command GRANT
grant privilege_name on table_name to user_name;
if there are multiple privileges then seperate using commas.
in the figure it's assigning all privileges to user "sonu"
similarly we can retrieve privilege using revoke command which is shown in the below figure.
grant privilege_name on table_name to user_name;
if there are multiple privileges then seperate using commas.
in the figure it's assigning all privileges to user "sonu"