Oracle内置角色connect与resource的权限(国外英文资料).doc

Oracle内置角色connect与resource的权限 Oracle built-in role connect and resource permissions First, the user connect role and resource roles are given by a command: Grant connect, the resource to the user; The permissions that users include when they are successful: CONNECT role: -- is the typical right that grants the end user, the most basic ALTER SESSION -- modify the SESSION CREATE CLUSTER -- CREATE clusters CREATE DATABASE LINK -- creates a DATABASE LINK CREATE SEQUENCE -- sets up the SEQUENCE CREATE SESSION -- establishes the SESSION CREATE SYNONYM -- CREATE synonyms CREATE VIEW -- CREATE a VIEW RESOURCE roles: -- for developers CREATE CLUSTER -- CREATE clusters CREATE PROCEDURE -- build the process CREATE SEQUENCE -- sets up the SEQUENCE CREATE TABLE -- build the TABLE CREATE TRIGGER -- creates a TRIGGER CREATE TYPE -- TYPE From dba_sys_privs, (note that you must log in as a DBA) : Select grantee, privilege from dba_sys_privs Where grantee = RESOURCE order by privilege; GRANTEE PRIVILEGE -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- The RESOURCE the CREATE CLUSTER The RESOURCE CREATE INDEXTYPE The RESOURCE CREATE OPERATOR The RESOURCE CREATE PROCEDURE The RESOURCE the CREATE SEQUENCE The RESOURCE CREATE TABLE The RESOURCE to CREATE the TRIGGER The RESOURCE the CREATE TYPE For example, this is the first time that you have to go to the end of the line What is the role? I explain permissions and users in the previous section. Slowly you will find a problem in use: if there is a group of people, their required permissions is the same, when their permissions for management will be very inconvenient. Because you have to manage the permissions of each user in this group. There is a good solution: the role. The role is a set of permissions, assigned to a user, who has all the pri