![]() ![]()
Click on the Run Script icon to execute the SQL script:ħ. Browse for sql script on the local directory (from step 2b) and open the sql script:ĭ. Run scripts: hr_cre.sql, hr_popul.sql, hr_idx.sql, hr_code.sql, hr_analz.sql You are currently connected as the HR user from previous step. Click Connect to connect to the database as the HR user. Note:- If you have selected SQL developer without JDK then you need to enter the JDK path in one of the windows. Now go to the folder and click on the sqldeveloper.exe file to start SQL Developer. Click Save to save the connection information for the HR user. Make sure the master folder name is SQL Developer. More from Seralahthan Installing Oracle SQL Developer on Ubuntu 16.04 LTS. Provide connection properties for the HR user: Setting up WSO2-IS with Docker Oracle Get an email whenever Seralahthan publishes. You will see the execution status on the bottom portion. Highlight all the commands and click on the Run Statement button.ĭ. Copy and paste the following commands to the SQL Worksheet:ĬREATE USER hr IDENTIFIED BY welcome1 ALTER USER hr DEFAULT TABLESPACE users QUOTA UNLIMITED ON users ALTER USER hr TEMPORARY TABLESPACE temp GRANT CREATE SESSION, CREATE VIEW, ALTER SESSION, CREATE SEQUENCE TO hr GRANT CREATE SYNONYM, CREATE DATABASE LINK, RESOURCE, UNLIMITED TABLESPACE TO hr You are currently connected as the SYS user from previous step. Click Connect to connect to the database as the SYS user. ![]() Click Save to save the connection information for the SYS user.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |