DB
DB:DB-001, oracle,오라클 다운로드, 및 id/pw 설정 및 권한 주기
sucun
2020. 5. 25. 17:22
sqlnoplus
sys as sysdba
1234
create user pytest001 identified by 1234
grant connect, resource, dba to pytest001;
conn pytest001/1234;
# hr unlock
conn/ as sysdba
alter user hr identified by hr account unlock;
conn hr/hr
select*from tab;
conn system/1234
@C:\app\oraclexe\app\oracle\product\11.2.0\server\rdbms\admin\scott.sql
alter user scott identified by tiger;
conn scott/tiger
select * from tab;
select *from tab;
DESC 테이블명
반응형