#2 DBMS_hr계정 연결

truelight92·2021년 11월 1일
0

DBMS

목록 보기
2/11
post-thumbnail

oracleDB XE11g R2, DBeaver 21.2.3

wihdow10

  1. hr 계정 연결
    1-1. Dbeaver 새 테이터베이스 연결하기
  • OracleDB Username : hr Password : 1234 (나머지 OracleDB 연결과 동일)

1-2. 테스트커넥션 오류시

  • cmd실행
    c:\User\Username>sqlplus
    Sql*Plus Release 11.2.0.2.0 Production on 현재시각
    Copyright(c) 1982, 2014, Oracle. All rights reserved.
    Enter user-name:system
    Enter password:1234(입력표시안됨)
    Connected to:
    Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
    SQL>alter user hr identified by hr account unlock;
    User altered.
    SQL>alter user hr identified by 1234;
    User altered.
    SQL>grant connect, resource to hr;
    Grant succeeded.

0개의 댓글