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

SQL tutorial 46: What are System Privileges & How To Grant them using Data Control Language

194 ratings | 23698 views
In this SQL Tutorial you will learn How To Grant System Privilege using Grant Data Control Language (DCL) along with ADMIN OPTION flag. First SQL Tutorial in the series of user privileges in oracle database ------------------------------------------------------------------------ ►►►Timeline◄◄◄ 1:50- Query 1- How To grant Basic System Privilege (i.e.Create Table system privilege) to a user 2:40- Query 2 - How to Grant Multiple System Privilege To a user in Single Grant (Data Control Language) Statement 3:52- Query 3 - How To grant System Privilege To Multiple Users in Single Grant (Data Control Language) Statement 4:50- Query 4- How To Grant System Privilege WITH ADMIN OPTION flag 5:26- WITH ADMIN OPTION demonstration ------------------------------------------------------------------------ Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog (Link for SQL Script is at the end of this article) : http://bit.ly/system_privilege_admin_option Link for How To create user ●SQL Tutorial 37 - Using Create User Statement http://youtu.be/4QbK2Y-1LZw ●SQL Tutorial 38- Using SQL Developer http://youtu.be/GS4udgR44Ls ●SQL Tutorial 39- Using Oracle Enterprise Manager http://youtu.be/zGjh-Bb3HrI List of few System Privileges Available in Oracle Database http://wp.me/p3r6sw-7M Previous Tutorial: Introduction To User Privileges http://youtu.be/iQFb86lM1gs ------------------------------------------------------------------------- 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 (5)
Chitwan Singla (10 months ago)
how to set port for pluggable database by pdb user
Chanda Mulengachanda (1 year ago)
awesome
Gurram Vinay (2 years ago)
Hey Mr.Manish #Query6:Grant system privilege to Role Demo1 GRANT select ON hr.employees TO demo1; having problem @ hr.emoloyees error code : oracle 00942:table view does not exist.
mahbubur rahman (4 years ago)
thank u buddy. just keep ur work up !
Khalil Nasrallah (4 years ago)
hello manish how is it going ? thank you very much for your helpful tutorials .. i've got ya a question and i would like you to explain it a bit .. cant we grant all privileges in  1  sql statement  using sqlplus  as i do  grant  all privileges to user ; and the deference between this statement and  grant any privileges to user ; and how can we grant system privileges to user in one sql statement usnig sqlplus? thank you very much  look forward to hearing from you

Would you like to comment?

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