Pages

How to create a role?

Example: Create role named changer on table students that will be able to update it. And give this role to user zeynal and david.

CREATE ROLE changer;

GRANT UPDATE ON students TO changer;
GRANT changer TO zeynal, david; 

No comments:

Post a Comment