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;