Lesson 7 : Oracle SQL DCL Tutorial | GRANT, REVOKE & CREATE USER Explained

#dcl #datacontrol #revoke #GRANT

🔐 Master SQL DCL Statements & Create Users in Oracle Database | Full Tutorial

In this video, you'll learn how to use SQL DCL (Data Control Language) statements like GRANT and REVOKE, and how to create a new user in Oracle Database using SQL commands. Perfect for beginners, DBA students, or anyone looking to manage user access and security in Oracle.

Timestamps(minutes:seconds)
0:00 Introduction
0:05 DCL statements
0:10 DCL expansion
0:27 Create new user in Oracle
1:06 Oracle database connect by using sqlplus
1:27 New user creation syntax
2:36 Grant privileges for new users
3:29 Show user
4:30 cl scr
6:04 Grant privileges to other user for table access
7:06 Revoke table access from other user
8:21 How to change Oracle user password by using alter command
8:28 exit
9:35 Drop the user
10:47 Purpose of DCL
11:18 End

📌 Topics Covered:
✅ What is DCL in SQL (GRANT & REVOKE)
✅ Syntax and examples of DCL commands
✅ How to create a new user in Oracle Database
✅ Assigning privileges with GRANT
✅ Revoking permissions from users
✅ Best practices for database access control

🔎 Examples Shown in This Video:
DCL - Data Control Language
Grant - Give the permission/privileges
Revoke - Remove already given permissions/privileges
sqlplus / as sysdba
SYS User
create user C##pavunu identified by 123;
grant create session to C##pavunu;
show user;
cl scr;
show user;
create table t1(a number);
insert into t1 values(10);
commit;
select * from t1;
grant select on t1 to C##pavunu;
revoke select on t1 from C##pavunu;
cl scr;
alter user C##pavunu identified by 1234;
drop user C##pavunu;

C##pavunu user
sqlplus c##pavunu/123
cl scr;
show user;
select * from SYS.T1;
cl scr;
exit
sqlplus c##pavunu/1234
cl scr
exit

Whether you're learning SQL for interviews, certifications, or hands-on database administration, this tutorial will help you understand both user creation and permission
management in Oracle.

👍 Like | 💬 Comment | 🔁 Share | 🔔 Subscribe for more SQL & Database Tutorials from Pavunu Education

🔔 Subscribe here : @PavunuEducation

how to create user in oracle
oracle sql grant role
revoke privileges oracle

#grant #revoke #datacontrol #dcl

Видео Lesson 7 : Oracle SQL DCL Tutorial | GRANT, REVOKE & CREATE USER Explained канала Pavunu Education