CONNECT role: --Typical rights granted to end users, the most basic
ALTER SESSION --modify session
CREATE CLUSTER --Create a cluster
CREATE DATABASE LINK --Create a database link
CREATE SEQUENCE --Create a sequence
CREATE SESSION --Create a session
CREATE SYNONYM --Create synonyms
CREATE VIEW --Create a view
RESOURCE role: --is granted to developers
CREATE CLUSTER --Create a cluster
CREATE PROCEDURE --Create process
CREATE SEQUENCE --Create a sequence
CREATE TABLE --Create table
CREATE TRIGGER --Create a trigger
CREATE TYPE --Create type
However, when actually searching the oracle 10 2.0.1.0 system, we found that the permissions of the two roles are as follows:
Log in to Oracle using sys and execute the following two statements:
select * from role_sys_privs WHERE ROLE LIKE 'CONNECT'; --Query the permissions of the connect role
select * from role_sys_privs WHERE ROLE LIKE 'RESOURCE'; --Query the permissions of the RESOURCE role
CONNECT role: --Typical rights granted to end users, the most basic
CREATE SESSION --Create a session
RESOURCE role: --is granted to developers
CREATE CLUSTER --Create a cluster
CREATE PROCEDURE --Create process
CREATE SEQUENCE --Create a sequence
CREATE TABLE --Create table
CREATE TRIGGER --Create a trigger
CREATE TYPE --Create type
CREATE OPERATOR --Create operator
CREATE INDEXTYPE --Create index type
CREATE TABLE --Create table
-