무회 Blog

DB:DB-001, oracle,오라클 다운로드, 및 id/pw 설정 및 권한 주기 본문

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 테이블명 

 

반응형
Comments