配置Oracle用户
--创建用户
create user pmes identified by pmes;
--查询用户
select * from dba_users;
--创建表空间
create tablespace ts_pmes datafile 'f:\pmes.dat' size 100m;
--修改用户缺省表空间为ts_pmes
alter user pmes default tablespace ts_pmes;
--给pmes用户授权
grant create session, create table, unlimited tablespace to pmes;
--查询用户拥有的权限
select * from session_privs;
--创建用户
create user pmes identified by pmes;
--查询用户
select * from dba_users;
--创建表空间
create tablespace ts_pmes datafile 'f:\pmes.dat' size 100m;
--修改用户缺省表空间为ts_pmes
alter user pmes default tablespace ts_pmes;
--给pmes用户授权
grant create session, create table, unlimited tablespace to pmes;
--查询用户拥有的权限
select * from session_privs;