Question

PLSQL怎么创建oracle数据库用户

Answer 1

登入sys用户，注意连接方式为sysdba ，然后创建用户表空间，然后创建用户指向你所创建的表空间，例子如下
创建表空间
CREATE TABLESPACE UPRR
DATAFILE 'E:\ORA_DB_UPRR\DATA_FILE\UPRR_0001.ORA' SIZE 100M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
创建用户
create user UPRR identified by UPRR
default tablespace UPRR
temporary tablespace temp;
GRANT create session,create trigger,create procedure, create sequence, create table, create view, create public synonym, drop public synonym TO UPRR;
ALTER USER UPRR QUOTA UNLIMITED ON UPRR;