SQL tutorial 48: How to create Roles in Oracle Database

4th SQL Tutorial in the series of user privileges in oracle database user Roles in Oracle Database. In this tutorial you will learn
● What user roles
● How to create simple roles (Role with Not Identified clause)
● How to create secure roles (Role with Identified clause)
● How to create external role.
● How To create global role.
● How to Grant System Privilege to a user Role
● How to Grant Object Privilege to a user Role In oracle database.
● How to grant a Role to another Role
● How To grant a role to database users (with Admin option)
● How To enable role using SET ROLE statement

This video will teach you the concept of user role in oracle database which is an extension to the user privileges. In this video I did 10 SQL queries on user Roles which makes this tutorial fun.

Celebrating 1000 subscribers. Thanks a lot guys for all your love and support.
------------------------------------------------------------------------
►►►LINKS◄◄◄

-------------------------------------------------------------------------
Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage

--------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the first one to see my videos!
--------------------------------------------------------------------------

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on

You can also Email me at

Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos

♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

[MasumsLanguageITZone]

thanks bro, I like your tutorials very much. It benefits   me very much. I learned a lot from your videos. Wish a happy life!

[tariqmehmood-ghkb]

thank you Manish for such knowledgeable tutorials.

[aryanpatle]

Hello Sir, I downloaded the Oracle sqldeveloper software and in connection, I forget my password of 'syst' connection.How can I access the connection again?

[prasunkarar]

nice post..!!! but how to view the privileges that has been assigned to a specific role(which is created by admin) ???

[sqlforeveryep]

in nutshell, ROLE, SCHEMA, and USER are same?

[laura]

Please help, I'm getting this error: ORA-47410: Realm violation for GRANT on CREATE TABLE

[saneeshsundaram]

do u have any profit by uploading oracle videos???

[mohamedhameed]

Hello Manish Sharma,

My role DEMO2 is not enabled even after enabling it using SET ROLE DEMO2 IDENTIFIED BY password123 stmt. I have even set GRANT DEMO1 to DEMO2, but users using DEMO2 does not have the same privileges as users using DEMO1.

Could you kindly tell me the reason for this?

Thanks in Advance

[timepassaction]

can u help me out for how to link 2 different database with each other using dblink.
please share video about auto job scheduler data refresh every 15 minutes

[zakirscamera]

hey sir
i need more info about privileges

[maheshKumar-puhr]

sir as you mentioned the previous video on system privileges, assigning roles are of same use what is the difference in it