Oracle db create new schema

-- 1st Step
CREATE USER user_name IDENTIFIED BY password;
-- 2nd step
GRANT RESOURCE TO user_name;
GRANT CONNECT TO user_name;
GRANT CREATE VIEW TO user_name;
GRANT CREATE SESSION TO user_name;
GRANT UNLIMITED TABLESPACE TO user_name;

Similar codes

3 votes181 views2 answers
Get current year sql
SQL
0 vote171 views1 answer
Lost connection to mysql
SQL
0 vote209 views1 answer
How to define a non primary composite key in sql
SQL
0 vote178 views1 answer
ORA-13717
SQL
0 vote226 views1 answer
Mysl like insert a variable
SQL
1 vote190 views1 answer
Mysql login console
SQL
0 vote163 views1 answer
Update set with join pl sql
SQL
1 vote212 views1 answer
Oracle drop temporary table
SQL
-1 vote186 views1 answer
Pl sql drop trigger
SQL
0 vote172 views1 answer
How to reset the database value in SQL server
SQL