Oracle SQL PLSQL 12C Tutorial 4 - Create New User

This Video Tutorial Will Describe how to create a new user in oracle 12C version. This command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on.

Full Syntax will be given in this video tutorial about how to create a new user in oracle database.

Along with the live example of the new user creating. In this video tutorial, we will create a new sample user like XYZ.

Then we will see how many other users are available using ALL_USER table, which is a predefined table available in oracle. Before the creation of new user and after the creation of the new table, we will examine the list of available user in oracle database.

[syedayazahmed]

Many thanks for excellent oracle 12c database tutorials, Appreciated
Please do add more oracle 12c database tutorials
Anticipating your response
Regards

[mayssounallahim]

i get "invalid common user or role name " error message . what should i do ?

[MuktiTheDarkRaven]

hey, is it possible to change the default username "sys" or "system" to something else? thanks

[harrypotter]

create user test identified by test ..