创建角色 并授权,,CONNECT角色被删除了..

 

CREATE USER RMSYS  PROFILE DEFAULT IDENTIFIED BY RMSYS DEFAULT TABLESPACE 

SYSTEM TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK

GRANT  CONNECT,DBA TO RMSYS WITH ADMIN OPTION

CREATE USER REPORT  PROFILE DEFAULT IDENTIFIED BY REPORT DEFAULT 

TABLESPACE SYSTEM TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK

GRANT  CONNECT,DBA TO  REPORT WITH ADMIN OPTION

 

 

-- Create the role
create role CONNECT;
-- Grant/Revoke system privileges
grant alter session to CONNECT;
grant create cluster to CONNECT;
grant create database link to CONNECT;
grant create sequence to CONNECT;
grant create session to CONNECT;
grant create synonym to CONNECT;
grant create table to CONNECT;
grant create view to CONNECT;