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

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◄◄◄
Link for How To create user
●SQL Tutorial 37 - Using Create User Statement
●SQL Tutorial 38- Using SQL Developer
●SQL Tutorial 39- Using Oracle Enterprise Manager

List of few System Privileges Available in Oracle Database

Previous Tutorial: Introduction To User Privileges

-------------------------------------------------------------------------
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

[SaadKhan-xrrt]

Error report -
ORA-04089: cannot create triggers on objects owned by SYS
04089. - "cannot create triggers on objects owned by SYS"
*Cause: An attempt was made to create a trigger on an object owned by SYS.
*Action: Do not create triggers on objects owned by SYS.

Can you provide the solution of that please .

[khalilnasrallah]

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

[Vinay_Gurram]

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.

[chitwansingla]

how to set port for pluggable database by pdb user