GNU/Linux |
RedHat 5.2(Apollo) |
|
![]() |
grant(l) |
![]() |
grant - grant access control to a user or group
grant <privilege[,privilege,...]>
on <rel1>[,...<reln>] | ||
to [public | group <group> | <username>] | ||
privilege is {ALL | SELECT | INSERT | UPDATE | DELETE | RULE} |
Grant allows you to give specified permissions to all users or a certain user or group. By default, only the table owner has rights.
--
--Example of a grant
--
grant insert
on mytab | |
to public |
revoke(l)
![]() |
grant(l) | ![]() |