Creating a user using sqlplus and connecting that user in sql developer

Опубликовано: 02 Октябрь 2024
на канале: Ishimwe William

479

#sqldeveloper #sqlplus
This video will allow you to create a user in sql plus and connect the user.
You will see how to connect the user in sql developer.

Scripts to create the user
-----------------------------------------
-- replace 'username with the user name you want
-- replace 'userpassword' with the user password
-- it is not mandatory to grant all access to the user

ALTER SESSION SET "_ORACLE_SCRIPT"=TRUE;
CREATE USER username IDENTIFIED BY userpassword;
GRANT ALL PRIVILEGES TO username;

2:58 connecting to sql developer

Used:
1. Oracle Database XE 21c
2. sqldeveloper: https://www.oracle.com/database/sqlde...