I'm gonna assume we're talking about MySQL, based on your previous question.
You should be able to use
Grant[
^] with
SqlCommand.ExecuteNonQuery()
E.g
mysqlcommand.CommandText = "CREATE USER 'KingBoy'@'localhost' IDENTIFIED BY 'KingBoys Password'";
mysqlcommand.ExecuteNonQuery();
mysqlcommand.CommandText = "GRANT SELECT, INSERT ON db1.* TO 'KingBoy'@'localhost'";
mysqlcommand.ExecuteNonQuery();