Oracle Database User management Activity

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

00:00 User Management in Oracle
00:18 Check number of user account
02:19 Check username
02:54 How to lock/unlock user account
05:27 How to create new user in database
07:36 Change user password
08:02 How to check database default tablespace
09:35 Grant/Revoke user permission
11:24 Grant quota on a tablespace to user
13:40 To change default tablespace of user
15:07 Drop a user

Website: https://www.dbagenesis.com/
Facebook:   / dbagenesis  
Instagram:   / dbagenesis  
Twitter:   / dbagenesis