Monday, April 27, 2009

create a oracle user authenticated by OS

1. make sure parameter OS_AUTHENT_PREFIX = "os_" is set.

2. create user in oracle database.

CREATE USER os_oracle IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
;

GRANT dba TO oracle;

exit;

3. make sure the user oracle is in OS dba group.

No comments: