HomeОбразованиеRelated VideosMore From: Manish Sharma

SQL tutorial 48: How to create Roles in Oracle Database

106 ratings | 22491 views
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◄◄◄ Blog: http://bit.ly/create_role_in_oracle System Privilege: http://youtu.be/EQzdtKPiErU Object Privilege: http://youtu.be/DuDL7NTPdqQ ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Html code for embedding videos on your blog
Text Comments (9)
mahesh Kumar (5 months ago)
sir as you mentioned the previous video on system privileges, assigning roles are of same use what is the difference in it
Prasun Karar (7 months ago)
nice post..!!! but how to view the privileges that has been assigned to a specific role(which is created by admin) ???
Aryan Patle (1 year ago)
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?
Ravindra Zade (1 year ago)
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
Zakir's Camera (2 years ago)
hey sir i need more info about privileges
tariq mehmood (2 years ago)
thank you Manish for such knowledgeable tutorials.
Manish Sharma (2 years ago)
+tariq mehmood Your most welcome. I am glad to be of help and hope to do so in future also.
masum khan (3 years ago)
thanks bro, I like your tutorials very much. It benefits   me very much. I learned a lot from your videos. Wish a happy life!
saneesh sundaram (3 years ago)
do u have any profit by uploading oracle videos???

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.