Creating roles and granting rights to the role I wanted to create a role called &quot;user_updates&quot; and this role should have the rights &quot;table_note_updates&quot;.
The rights called &quot;table_note_updates&quot; is already available in my database. How to grant the rights to role that i create.
A role can be granted to another role.
create role user_updates;
grant table_note_updates to user_updates;