How to create user and provide the privilege in Oracle Database step by step
🔐 In this video, you'll learn how to create a new user in Oracle Database and grant it the necessary privileges using SQL commands. Whether you're a DBA, developer, or student, this step-by-step tutorial will help you understand user management in Oracle.
📌 What you'll learn:
0:00 – Introduction
0:30 – Connecting as SYSDBA
1:00 – Creating a new user
1:30 – Granting session and role privileges
2:30 – Testing the user login
3:00 – Summary
✅ Commands used:
```sql
CREATE USER test_user IDENTIFIED BY test_password;
grant create session, create table, insert any table , update any table, drop any table, UNLIMITED TABLESPACE to test_user;
🔧 Tools used:
Oracle Database
SQL*Plus / SQL Developer
👍 Like, share, and subscribe for more Oracle Database tutorials!
📘 Related videos:
How to Install Oracle Database
How to Use SQL Developer
#OracleDatabase #OracleUser #SQL #DatabaseAdmin #OraclePrivileges #DBATutorial #SQLTutorial #OracleDB #UserCreation #databasesecurity