oracle给表赋清空权限,oracle建表赋权限

oracle建表赋权限

--创建表空间

create tablespace ya

logging

datafile 'D:\Oracle\product\10.2.0\oradata\oracle\ya.dbf'

size 32m

autoextend on

next 32m maxsize 2048m

extent management local;

--创建临时表空间

create temporary tablespace ya_temp

tempfile 'D:\Oracle\product\10.2.0\oradata\oracle\ya_temp.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local

--删除表空间

--DROP TABLESPACE ya_temp INCLUDING CONTENTS AND DATAFILES;

--创建用户并指定表空间

create user ya identified by ya

default tablespace  ya

temporary tablespace ya_temp;

--赋权限

grant connect,resource to ya;

grant exp_full_database,imp_full_database,resource,create any sequence to ya;

grant create any trigger,create any view,create table,drop any view to ya;

grant exp_full_database,imp_full_database,resource,create any sequence to ya;

grant create session to ya;

grant create any table to ya;//授权创建表； grant create session to ya; -- --alter tablespace CHINAEB_01DAT online; --alter database datafile 'E:\oracle\product\10.2.0\oradata\chinaeb\CHINAEB_01DAT.dbf' online; --alter tablespace CHINAEB_01DAT read only; --alter tablespace CHINAEB_01DAT read write; --grant create session to samsung; --drop user ya cascade;