Content Comparison

############################################
# Connect SYS : SYS 계정으로 접속함.
############################################
Mach> create user demo identified by 'demo';
Created successfully.

Mach> 
drop user demo;
Dropped successfully.

Mach>
 create user demo1 identified by 'demo1';
Created successfully.

Mach> create user demo2 identified by 'demo2';
Created successfully.

Mach> 
alter user demo2 identified by 'demo22';
Altered successfully.

Mach>
 create table demo1_table (id integer);
Created successfully.

Mach> 
create bitmap index demo1_table_index1 on demo1_table(id);
Created successfully.

Mach>
 insert into demo1_table values(99991);
1 row(s) inserted.

Mach> insert into demo1_table values(99992);
1 row(s) inserted.

Mach> insert into demo1_table values(99993);
1 row(s) inserted.

Mach> 
select * from demo1_table;
ID
--------------
99993
99992
99991
[3] row(s) selected.
Mach>

#Error: 자기 자신을 Drop 할 수 없음.
Mach> drop user SYS;
[ERR-02083 : Drop user error. You cannot drop yourself(SYS).]
Mach>

############################################
# Connect DEMO1
############################################
Mach> connect demo1/demo1;
Connected successfully.
Mach>

#Error: 일반 유저는 다른 사용자의 비밀번호를 바꿀 수 없다.
Mach> alter user demo2 identified by 'demo22';
[ERR-02085 : ALTER user error. The user(DEMO2) does not have ALTER privileges.]

Mach> 
alter user demo1 identified by demo11;
Altered successfully.

Mach>
 connect demo2/demo22;
Connected successfully.
Mach>

#Error: wrong password
co``````````````nnectMach> connect demo1/demo11234;
 [ERR-02081 : User authentication error. Invalid password (DEMO11234).]
Mach>

# Correct password
Mach> connect demo1/demo11;
Connected successfully.

Mach> 
create table demo1_table (id integer);
Created successfully.

Mach> 
create bitmap index demo1_table_index1 on demo1_table(id);
Created successfully.

Mach>
 insert into demo1_table values(1);
1 row(s) inserted.

Mach> insert into demo1_table values(2);
1 row(s) inserted.

Mach> insert into demo1_table values(3);
1 row(s) inserted.

Mach>
 select * from demo1_table;
ID
--------------
3
2
1
[3] row(s) selected.

Mach> select * from demo1.demo1_table;
ID
--------------
3
2
1
[3] row(s) selected.
Mach>

############################################
# Connect SYS again
############################################
Mach> connect SYS/MANAGER;
Connected successfully.

Mach> 
select * from demo1_table;
ID
--------------
99993
99992
99991
[3] row(s) selected.

Mach>
 select * from demo1.demo1_table;
ID
--------------
3
2
1
[3] row(s) selected.
Mach>

#Error: demo1 유저에 속한 테이블이 존재함.
Mach> drop user demo1;
[ERR-02084 : DROP user error. The user's tables still exist. Drop those tables first.]

Mach> 
connect demo1/demo11;
Connected successfully.

Mach> 
drop table demo1_table;
Dropped successfully.

Mach>
 connect SYS/MANAGER;
Connected successfully.

Mach> 
drop user demo1;
Dropped successfully.
Mach>