Скачать или смотреть DCL statements

In this video, I have explained DCL ( Data Control Language) Commands in detail-
1. GRANT
2. REVOKE

Video Link -    • DCL statements  

Click here to subscribe to my you tube channel    / @codewithrahul1465  

#CodeWithRahul #SQL #Oracle #HappyLearning

If you learn something new from this video, please like this video and subscribe to my channel
CodeWithRahul

DCL Commands :

--- CREATE NEW USER
alter session set container = ORCLPDB;

create user rahul_test2 identified by Oracle;

grant create session to rahul_test2;
grant create table to rahul_test2;
grant create view to rahul_test2;


-- connect to rahul_test1 user
select * from department;

create table department(dept_id int, dept_name varchar2(50));

-- grant Select permission to rahul_test3
grant select on department to rahul_test2;

-- Revoke permissions on employee table from rahul_test3
revoke select on department from rahul_test2;