oracle 创建用户并授权

来源：互联网发布：linux进程与线程的区别编辑：程序博客网时间：2024/04/27 15:53

创建用户临时的表空间
CREATE TEMPORARY TABLESPACE portal_temp
TEMPFILE 'D:\app\patrol\oradata\orcl\portal_temp.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;

创建用户表空间
create tablespace portal_data
LOGGING
DATAFILE 'D:\app\patrol\oradata\orcl\portal_data.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;

创建用户并制定表空间
create user portal identified by orcl
DEFAULT TABLESPACE portal_data
TEMPORARY TABLESPACE portal_temp;

授权：
2.grant create table,create view,create trigger, create sequence,create procedure to portal;--分配创建表，视图，触发器，序列，过程权限

grant create session,resource to portal;
GRANT DBA TO portal;
GRANT RESOURCE TO portal;
ALTER USER portal DEFAULT ROLE ALL;
GRANT SELECT ANY TABLE TO portal;
GRANT UNLIMITED TABLESPACE TO portal;
GRANT CREATE ANY TABLE to portal;

0 0