ORACLE ORA-28009/ORA-01017 와 Grant 권한 부여

■ ORA-28009

Enter user-name: SYS Enter password: ERROR: ORA-28009: SYS(SYSDBA 또는 SYSOPER)로 접속해야 합니다.

> sqlplus 로 오라클DBMS 접속하여 SYS시 뜨는 오류코드 > 필요하다면 sqlplus / as sysdba 로 진입하자

 

■ ORA-01017

Enter password: ERROR: ORA-01017: 사용자명/비밀번호가 부적합, 로그온할 수 없습니다.

> 오라클 DB를 설치한 서버에서 sqlplus / as sysdba로 접속하면 관리자가 접속한것으로 판단하여 접속이 됨. > 근데 패스워드를 요구한다? sqlplus /as sysdba 같은 타이핑 실수인지 확인하도록 하자.

 

---

사내 개발자 중 한명이 연락을 했다.

 

GRANT 권한을 확인해보자.

SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE = '{}_DEV';

GRANTEE -------------------------------------------------------------------------------- PRIVILEGE -------------------------------------------------------------------------------- ADMIN_OPT --------- {}_DEV CREATE TABLE NO {}_DEV UNLIMITED TABLESPACE NO GRANTEE -------------------------------------------------------------------------------- PRIVILEGE -------------------------------------------------------------------------------- ADMIN_OPT --------- {}_DEV SELECT ANY DICTIONARY NO {}_DEV CREATE ANY PROCEDURE GRANTEE -------------------------------------------------------------------------------- PRIVILEGE -------------------------------------------------------------------------------- ADMIN_OPT --------- NO {}_DEV SELECT ANY SEQUENCE NO {}_DEV GRANTEE -------------------------------------------------------------------------------- PRIVILEGE -------------------------------------------------------------------------------- ADMIN_OPT --------- CREATE SYNONYM NO {}_DEV CREATE ANY TYPE NO GRANTEE -------------------------------------------------------------------------------- PRIVILEGE -------------------------------------------------------------------------------- ADMIN_OPT --------- {}_DEV SELECT ANY TABLE NO {}_DEV CREATE ANY TRIGGER NO GRANTEE -------------------------------------------------------------------------------- PRIVILEGE -------------------------------------------------------------------------------- ADMIN_OPT --------- {}_DEV CREATE VIEW NO

insert 권한이 없다 추가해주자.

SQL> GRANT INSERT ANY TABLE TO {}_DEV; Grant succeeded.

SQL> SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE = '{}_DEV'; GRANTEE -------------------------------------------------------------------------------- PRIVILEGE -------------------------------------------------------------------------------- ADMIN_OPT --------- {}_DEV CREATE TABLE NO {}_DEV UNLIMITED TABLESPACE NO GRANTEE -------------------------------------------------------------------------------- PRIVILEGE -------------------------------------------------------------------------------- ADMIN_OPT --------- {}_DEV SELECT ANY DICTIONARY NO {}_DEV CREATE ANY PROCEDURE GRANTEE -------------------------------------------------------------------------------- PRIVILEGE -------------------------------------------------------------------------------- ADMIN_OPT --------- NO {}_DEV SELECT ANY SEQUENCE NO {}_DEV GRANTEE -------------------------------------------------------------------------------- PRIVILEGE -------------------------------------------------------------------------------- ADMIN_OPT --------- CREATE SYNONYM NO {}_DEV CREATE ANY TYPE NO GRANTEE -------------------------------------------------------------------------------- PRIVILEGE -------------------------------------------------------------------------------- ADMIN_OPT --------- {}_DEV SELECT ANY TABLE NO {}_DEV CREATE ANY TRIGGER NO GRANTEE -------------------------------------------------------------------------------- PRIVILEGE -------------------------------------------------------------------------------- ADMIN_OPT --------- {}_DEV INSERT ANY TABLE NO {}_DEV CREATE VIEW GRANTEE -------------------------------------------------------------------------------- PRIVILEGE -------------------------------------------------------------------------------- ADMIN_OPT --------- NO 11 rows selected.

 

 

 

마리아, 오라클, 티베로 스키마 계정 권한 부여(Grant) :: 제고

마리아, 오라클, 티베로 스키마 계정 권한 부여(Grant)