Thursday , June 13 2024

Oracle Create User

In today’s article, I will explain how to create a user. The person who will create a user in the database must have “CREATE USER” system privilege.

When creating a user:

What will be the username,

powers to be given,

What will be the default Tablespace,

We have to consider what the default Temprorary Tablespace will be.

The minimum authorization to be given to the user is the “CREATE SESSION” authorization. Otherwise, the user cannot connect to the database.

SQL SENTENCES

NOTES

If the SIGN user creates a new object and does not specify a special tablespace with the word “TABLESPACE”, USERS is created in the tablespace by default.

Loading

About Onur ARDAHANLI

Leave a Reply

Your email address will not be published. Required fields are marked *

Categories