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