I have seen one Post on facebook in Oracle DB group that someone is asking, How to create user in oracle database. I know it's very silly question but it happens if you are new to Oracle. So I am only writing this post for those people how do not want to study the books. So here are the steps to create user in Oracle database. Theses steps will be same in 10g,11g and 12c. I will discuss two scenarios here :- create simple user create user with attributes Create simple user Step1 :- You can connect to database with sysdba privileges. e.g. sql > conn / as sysdba Step2:- After connecting to sysdba, you need to use “CREATE USER” command to create new user. “ALTER USER” is used to modify the properties of the users like password, profile etc. Please note that users name should be unique. You cannot create user wit the same name. e.g. sql > create user test identified by test; Step 3:- With ab...