CODEWITHSUNDEEP
oracle-databaserdbmsoracle19c
vamsi saggurthi
vamsi saggurthi

Reputation: 71

how to create user in oracle 19c database

after installing oracle 19 C it was asking for username and password. what to type in that and how to create a new user with all permissions and authentication rights.(note i tried create user command by login as SYSDBA but it showing error as invalid common user or role name. enter image description here

[enter image description here][2]

Upvotes: 0

Views: 20409

Answers (3)

ARUN
ARUN

Reputation: 7

alter session set "_ORACLE_SCRIPT"=true;

After execute the above script user has been created.

Upvotes: -2

Subarata Talukder
Subarata Talukder

Reputation: 6311

To create a user in a particular container do follows:

  • alter session set container
  • Crate user

Example:

  • alter session set "_ORACLE_SCRIPT"=true;
  • CREATE USER your_user_name IDENTIFIED BY your_password

After finished user creation please add grant permission to your user. Otherwise you may not be able to login in with this user.

  • GRANT Dba to your_user_name

Upvotes: 1

SOFIANE AIT SAID
SOFIANE AIT SAID

Reputation: 31

create user c##yourusername identified by tiger;

Upvotes: 3

Related Questions