What is USER Management?

Rameshdba.com

   The contents are of my own testing and deployments. Not guaranteed that these might work in your environment. Please test before usage.


Summary: In this session, I will teach you About User management in oracle database.

  •  The user is basically used to connect to the database. All db objects like table, index, view, etc can be created under that user.
  •   In Oracle, users and schemas are essentially the same things. You can consider that a user is an account you use to connect to a database, 
  • Schema is the set of objects (tables, views, etc.) that belong to that account.

1.  HOW TO CREATE A USER?







2. HOW TO CHANGE THE PASSWORD?



3. HOW TO LOCK/UNLOCK THE USER?


4. HOW TO CHANGE THE DEFAULT TABLESPACE OF A USER?


                                Thanks you for your time!!!

0 Comments

DELETE Statement in ORACLE DB— Step by Step Internal Flow with classroom example.

by
Imagine your Oracle database like a school, and you’re Teacher decides to remove a student (row) from the classroom(table). Let’s see how the journey works step by step: 1)Classroom = Oracle Table 2)Students = Rows (Records) 3)Class Teacher = Oracle Server Process 4)Attendance Register = Data Dictionary User fires DELETE statement: DELETE FROM students WHERE grade = 'D'; Internal Processing Steps: Client Process Sends DELETE Statement to Server Process The teacher receives a request to remove a student from the classroom. Syntax Check (Parsing) The teacher checks if the request is grammatically correct — proper command, keywords, and a semicolon. Semantic Check Teacher verifies if the classroom exists and whether the condition (like grade = 'D') makes sense. Object Resolution Teacher confirms that the ‘students’ classroom (table) exists in the school records (data dictionary). Optimization Decides the fastest way to find those students — by roll number, grade, or al...
Image