ORACLE ORA-01017

Oracle 권한 설정

 

1. sqlplus / as sysdba

2. select username from all_users;

3. create user user_name identified by password;

4. alter user user_name identified by new_password;

5. grant connect, resource to user_name

 

// 대소문자 구분 false로 설정

 

1. show parameter sec_case;

2. alter system set sec_case_sensitive_logon=fasle;