Pages

How to give grant on an object?

Example: Give SELECT, UPDATE grants on students table to user zeynal. And also he will be able to grant this roles to anyone.

GRANT SELECT, UPDATE ON students TO zeynal WITH GRANT OPTION
;

Note: if we want to give all privileges we can use ALL clause,

GRANT ALL ON students TO zeynal WITH GRANT OPTION;

No comments:

Post a Comment