SQL 초기 설정 (Oracle)

 

 

[SQL 설정]
cmd창 -> sqlplus / as sysdba -> alter user hr account unlock; -> alter user hr identified by 1234;

-> conn hr/1234 -> select * from tabs; 

sqlplus system/1234 -> alter user scott indentified by 1234 account unlock; ->

@C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\admin\scott -> show user; -> desc emp; 

sqlplus system/1234 -> clear -> alter user scott identified by 1234; -> conn scott/1234

[새로운 계정 생성]
cmd창 -> sqlplus / as sysdba - create user 계정이름 identified by 1234; - alter user 계정이름 identified by 1234; -  grant connect, resource, dba to 계정이름; - commit;