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;