Versions Compared

Version Old Version 3 New Version 4
Changes made by

Hyeonmin Lee (Unlicensed)

Hyeonmin Lee (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

사용자 생성

create_user_stmt:

Image Added

Code Block
create_user_stmt ::= 'CREATE USER' user_name 'IDENTIFIED BY' password


사용자를 생성하는 구문은 다음과 같다.

Code Block
--예제
CREATE USER USERnew_NAMEuser IDENTIFIED BY PASSWORDpassword


Ui text box
typenote

비밀번호의 최대 길이는 8글자이다.


사용자 삭제

drop_user_stmt:

Image Added

Code Block
drop_user_stmt ::= 'DROP USER' user_name


사용자를 삭제하는 구문은 다음과 같다. SYS 사용자는 삭제할 수 없으며, 삭제 대상 사용자가 이미 생성한 테이블이 있을 경우에는 에러를 나타낸다.

Code Block
--예제
DROP USER USERold_NAMEuser


사용자 비밀번호 변경

alter_user_pwd_stmt:

Image Added

Code Block
alter_user_pwd_stmt ::= 'ALTER USER' user_name 'IDENTIFIED BY' password


사용자는 아래의 구문을 통해 비밀번호를 변경할 수 있다.

Code Block
--예제
ALTER USER USER_NAMEuser1 IDENTIFIED BY PASSWORDpassword


사용자 재접속

user_connect_stmt:

Image Added

Code Block
user_connect_stmt: 'CONNECT' user_name '/' password


사용자는 응용 프로그램을 종료하지 않고, 다음의 구문을 통해 다른 사용자로 재접속할 수 있다.

Code Block
--예제
CONNECT USER_NAMEuser1/PASSWORDpassword;


사용자 사용 예

Code Block
############################################3
# Connect SYS
############################################3
Create user demo identified by 'demo';

drop user demo;

create user demo1 identified by 'demo1';
create user demo2 identified by 'demo2';

alter user demo2 identified by 'demo22';

create table demo1_table (id integer);

create bitmap index demo1_table_index1 on demo1_table(id);

insert into demo1_table values(99991);
insert into demo1_table values(99992);
insert into demo1_table values(99993);

select * from demo1_table;

#Error
drop user SYS;

############################################
# Connect DEMO1
############################################
connect demo1/demo1;

#Error
alter user demo2 identified by 'demo22';

alter user demo1 identified by demo11;


connect demo2/demo22;

#Error: wrong password
connect demo1/demo11234;

# Correct password
connect demo1/demo11;

create table demo1_table (id integer);

create bitmap index demo1_table_index1 on demo1_table(id);

insert into demo1_table values(1);
insert into demo1_table values(2);
insert into demo1_table values(3);

select * from demo1_table;

select * from demo1.demo1_table;

############################################
# Connect SYS again
############################################
connect SYS/MANAGER;

select * from demo1_table;

select * from demo1.demo1_table;

#Error
drop user demo1;

connect demo1/demo11;

drop table demo1_table;

connect SYS/MANAGER;

drop user demo1;

...