oracle user 생성
1. user 생성a. 일반 접속만 되는 user conn / as sysdba;undefine UserName;create user &&UserName identified by "&Password" /select username from dba_users where username=upper('&UserName') /prompt Show Grant!!!! select grantee, privilege from dba_sys_privs where grantee=upper('&UserName') /undefine UserName; b. schema 유저(객체를 소유한 유저)- quota,create table,create index, create procedure,create view, etc conn /..
DataBase/Oracle
2012. 10. 17. 11:43