Scratch the vine uncles learn oracle_ create a new user and authorize

################################

Oracle ' _ New user and authorize

################################

--Suggest to execute orders with SYSDBA account

--View existing users of the database
SELECT * from Dba_users
--Create User test
CREATE USER Test
Identified by Test
DEFAULT tablespace Test
Temporary tablespace Temp
QUOTA 30M on users;

3. Granting of authority (execution of orders in SYSDBA account)
--Grant DBA Authority
Grant DBA to Test;

January 1, 2015 Thursday 22:17 33 seconds

Mindong in Hefei, Anhui Province

Scratch the vine uncles learn oracle_ create a new user and authorize