Oracle built-in role connect and resource Permissions

First, use a command to grant the user the "connect" and "resource" roles: grantconnect and resourcetouser. After the operation is successful, the user has the following permissions: the "CONNECT" role.

First, use a command to grant the user the connect role and the resource role: grant connect, resource to user; after the operation is successful, the user includes the permission: CONNECT role

Homepage → Database Technology

Background:

Read News

Oracle built-in role connect and resource Permissions

[Date:] Source: Oracle community Author: Oracle edit [Font:]

First, use a command to grant the user the connect role and the resource role:

Grant connect, resource to user;

Permissions granted to the user after successful running:

CONNECT role: -- is the most basic and typical right granted to end users.
Alter session -- modify a 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 a SYNONYM
Create view -- CREATE VIEW

RESOURCE role: -- grant permissions to developers
Create cluster -- CREATE a CLUSTER
Create procedure -- creation process
Create sequence -- CREATE a SEQUENCE
Create table -- CREATE a TABLE
Create trigger -- CREATE a TRIGGER
Create type -- CREATE TYPE

You can find it in dba_sys_privs (note that you must Log On As a dba ):
Select grantee, privilege from dba_sys_privs
Where grantee = 'resource' order by privilege;

GRANTEE PRIVILEGE
----------------------------------
RESOURCE CREATE CLUSTER
RESOURCE CREATE INDEXTYPE
RESOURCE CREATE OPERATOR
RESOURCE CREATE PROCEDURE
RESOURCE CREATE SEQUENCE
RESOURCE CREATE TABLE
RESOURCE CREATE TRIGGER
RESOURCE CREATE TYPE

0

Use sysdate in Oracle as the chat room instant time

Management of Datafiles in Oracle

Oracle

Image Information

View All comments in this article (0)

Comments

Latest Information

Popular this week

Introduction to Linux community-advertisement service-website map-help Info-contact us
The articles published on this site (LinuxIDC) do not mean that they agree with the statement or description. They only provide more information and do not constitute any suggestions.


Copyright©2006-2014 Linux community All rights reserved Zhejiang ICP backup No. 06018118