美文网首页
Oracle创建表空间和用户脚本

Oracle创建表空间和用户脚本

作者: Acamy丶 | 来源:发表于2018-03-06 10:14 被阅读0次
    -- 删除用户和表空间
    drop user INTEPDM cascade;
    DROP TABLESPACE INTEPDM INCLUDING CONTENTS AND DATAFILES;
    
    --创建表空间
    create tablespace INTEPDM logging  
    datafile 'D:\oracle\oradata\orcl\INTEPDM.dbf' 
    size 50m  
    autoextend on  
    next 50m maxsize 20480m  
    extent management local;  
    
    
    --创建用户  
    create user INTEPDM profile default identified by "Ghost" default  
    tablespace INTEPDM temporary tablespace TEMP account unlock;  
    
    --给用户授权
    GRANT "CONNECT" TO INTEPDM;
    GRANT "RESOURCE" TO INTEPDM;
    grant connect,resource,dba to INTEPDM; 
    grant create cluster to INTEPDM;
    grant create database link to INTEPDM;
    grant create procedure to INTEPDM;
    grant create sequence to INTEPDM;
    grant create table to INTEPDM;
    grant create trigger to INTEPDM;
    grant create type to INTEPDM;
    grant create view to INTEPDM;
    grant debug any procedure to INTEPDM;
    grant debug connect session to INTEPDM;
    grant select any dictionary to INTEPDM;
    

    相关文章

      网友评论

          本文标题:Oracle创建表空间和用户脚本

          本文链接:https://www.haomeiwen.com/subject/bhdlfftx.html