oracle创建表及设置权限设置,oracle创建表空间、用户，并设置权限和表空间

创建表空间

CREATE TABLESPACE CSM_STAND

LOGGING

DATAFILE 'D:\oracle\product\10.2.0\oradata\orcl\CSM_STAND.DBF'

SIZE 32M

AUTOEXTEND ON

NEXT 32M MAXSIZE 2048M

EXTENT MANAGEMENT LOCAL;

创建用户并设置表空间

create user csm_stand identified by csm default tablespace csm_stand;

给用户赋权限

grant connect,resource to csm_stand;

grant create any sequence to csm_stand;

grant create any table to csm_stand;

grant delete any table to csm_stand;

grant insert any table to csm_stand;

grant select any table to csm_stand;

grant unlimited tablespace to csm_stand;

grant execute any procedure to csm_stand;

grant update any table to csm_stand;

grant create any view to csm_stand;

给用户赋予DBA权限

grant dba to csm_stand;

取消用户的所有权限

revoke dba from

删除表空间

alter tablespace CSM_TEST offline;

DROP TABLESPACE CSM_TEST INCLUDING CONTENTS AND DATAFILES;

感谢您的阅读，希望对您有帮助，本文版权归 #惊讶# 所有