查看当前用户权限:
select * from user_sys_privs;
查看所有用户:
select * from all_users;
查看dba用户:
select * from dba_users;
查看表空间:
select * from dba_tablespaces;
查看表空间文件
select * from dba_data_files;
创建表空间:
create tablespace CMS
logging
datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\tbl_CMS01.dbf'
size 32m
autoextend on
next 32m maxsize 20480m
extent management local;
--创建cms用户
create user cms identified by cms_bingo_itc default tablespace CMS;
/*第4步:给用户授予权限 */
grant connect,resource,dba to cms;
select * from user_sys_privs;
查看所有用户:
select * from all_users;
查看dba用户:
select * from dba_users;
查看表空间:
select * from dba_tablespaces;
查看表空间文件
select * from dba_data_files;
创建表空间:
create tablespace CMS
logging
datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\tbl_CMS01.dbf'
size 32m
autoextend on
next 32m maxsize 20480m
extent management local;
--创建cms用户
create user cms identified by cms_bingo_itc default tablespace CMS;
/*第4步:给用户授予权限 */
grant connect,resource,dba to cms;