下面是在SQL*PLUS中创建用户和授权CONN SYSTEM/MANAGER@服务名;//连接数据库 建表空间及数据文件。 CREATE TABLESPACE TEST //建表空间及数据文件。 DATAFILE '&DATAFIL\TEST.ORA' SIZE 50M REUSE AUTOEXTEND ON NEXT 10M DEFAULT STORAGE(INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS 8192 PCTINCREASE 0) ONLINE PERMANENT;CREATE USER TEST IDENTIFIED BY TEST //创建用户 DEFAULT TABLESPACE TEST TEMPORARY TABLESPACE &TEMPTABLESPACE_NAME PROFILE DEFAULT;GRANT CONNECT,RESOURCE TO TEST;
sqlplus /nolog conn sys/manager as sysdba; create user <user> identified by <password>; grant dba to <user>; conn <user>/<password>; select sysdate from dual;
--创建用户表空间 create tablespace cp01_data datafile '/home/oracle/oradata/cpzb/cp01_data01.dbf' size 10m autoextend on next 5m maxsize 2000m, '/home/oracle/oradata/cpzb/cp01_data02.dbf' size 10m autoextend on next 5m maxsize 2000m default storage(initial 128k next 128k pctincrease 0 maxextents 16000); --创建用户 create user cp01 identified by cp01 default tablespace cp01_data temporary tablespace temp quota unlimited on cp01_data; ----授权 grant connect,resource to cp01;
建表空间及数据文件。
CREATE TABLESPACE TEST //建表空间及数据文件。
DATAFILE '&DATAFIL\TEST.ORA' SIZE 50M REUSE
AUTOEXTEND ON NEXT 10M
DEFAULT STORAGE(INITIAL 128K NEXT 128K
MINEXTENTS 1 MAXEXTENTS 8192 PCTINCREASE 0)
ONLINE PERMANENT;CREATE USER TEST IDENTIFIED BY TEST //创建用户
DEFAULT TABLESPACE TEST
TEMPORARY TABLESPACE &TEMPTABLESPACE_NAME
PROFILE DEFAULT;GRANT CONNECT,RESOURCE TO TEST;
conn sys/manager as sysdba;
create user <user> identified by <password>;
grant dba to <user>;
conn <user>/<password>;
select sysdate from dual;
create tablespace cp01_data datafile
'/home/oracle/oradata/cpzb/cp01_data01.dbf' size 10m autoextend on next 5m maxsize 2000m,
'/home/oracle/oradata/cpzb/cp01_data02.dbf' size 10m autoextend on next 5m maxsize 2000m
default storage(initial 128k next 128k pctincrease 0 maxextents 16000);
--创建用户
create user cp01 identified by cp01
default tablespace cp01_data
temporary tablespace temp
quota unlimited on cp01_data;
----授权
grant connect,resource to cp01;
安全性->用户->创建
可以分配角色,系统权限.....