oracle用户创建相关信息

最新推荐文章于 2021-08-29 19:00:51 发布

petercnmei

最新推荐文章于 2021-08-29 19:00:51 发布

阅读量300

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/petercnmei/article/details/51895090

版权

数据库专栏收录该内容

21 篇文章 0 订阅

订阅专栏

-- Create profile
create profile PROFILE_APP limit
  sessions_per_user 100
  idle_time 15;

-- Create the role
create role ROLE_APPUSER;
-- Grant/Revoke role privileges
grant connect to ROLE_APPUSER;
-- Grant/Revoke system privileges
grant create database link to ROLE_APPUSER;
grant create external job to ROLE_APPUSER;
grant create indextype to ROLE_APPUSER;
grant create job to ROLE_APPUSER;
grant create materialized view to ROLE_APPUSER;
grant create measure folder to ROLE_APPUSER;
grant create operator to ROLE_APPUSER;
grant create procedure to ROLE_APPUSER;
grant create profile to ROLE_APPUSER;
grant create role to ROLE_APPUSER;
grant create rule to ROLE_APPUSER;
grant create rule set to ROLE_APPUSER;
grant create sequence to ROLE_APPUSER;
grant create session to ROLE_APPUSER;
grant create synonym to ROLE_APPUSER;
grant create table to ROLE_APPUSER;
grant create trigger to ROLE_APPUSER;
grant create type to ROLE_APPUSER;
grant create user to ROLE_APPUSER;
grant create view to ROLE_APPUSER;

--会员系统

CREATE SMALLFILE
    TABLESPACE "TBL_HYXT"
    LOGGING
    DATAFILE '/ora_dat/datafile/oradev/TBL_HYXT01.dbf' SIZE 256M AUTOEXTEND
    ON NEXT  100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
    SEGMENT SPACE MANAGEMENT  AUTO ;

CREATE SMALLFILE
    TABLESPACE "IDX_HYXT"
    LOGGING
    DATAFILE '/ora_dat/datafile/oradev/IDX_HYXT01.dbf' SIZE 256M AUTOEXTEND
    ON NEXT  100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
    SEGMENT SPACE MANAGEMENT  AUTO ;

-- Create the user
create user dbrw_hyxt
  identified by dbrw_hyxt
  default tablespace TBL_HYXT
  temporary tablespace TEMP
  profile PROFILE_APP
  quota unlimited on tbl_hyxt
  quota unlimited on idx_hyxt;
-- Grant/Revoke role privileges
grant role_appuser to dbrw_hyxt ;