After the creation,you need to grant some privileges to the role.Suppose, I have different posts in organization like manager and executive. I will create a role named " MANAGER_ROLE".
Now, its time to assign some privileges to that created role. I want to grant only SELECT, INSERT AND UPDATE PRIVILEGE to the manager of every managers.That would be as follows :
Code:
CREATE ROLE MANAGER_ROLE
IDENTIFIED BY MAN123;
Granting the privilege to the role:
Code:
GRANT SELECT,INSERT,UPDATE ON <Object_name> TO MANAGER_ROLE;
Bookmarks