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

Oracle内置角色connect与resource的权限(国外英文资料) The built-in Oracle role of connect and resource permissions First, a command gives user users connect role and the role of resource: Grant connect, resource to user; After the success of the operation including user permissions: CONNECT role: - is typical of right to the end user, the most basic ALTER SESSION - revision session CREATE CLUSTER - the establishment of cluster CREATE DATABASE LINK - database link CREATE SEQUENCE - the establishment of sequence CREATE SESSION - a session CREATE SYNONYM: create synonym CREATE VIEW - based view The role of RESOURCE is granted to developers: CREATE CLUSTER - the establishment of cluster The process of establishing CREATE - PROCEDURE CREATE SEQUENCE - the establishment of sequence CREATE TABLE - table CREATE TRIGGER - create trigger CREATE TYPE - type building The dba_sys_privs can be found in (note here must be based on the role of DBA login): Select grantee, privilege from dba_sys_privs Where grantee=RESOURCEorder 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 ================================================= First, what is the role? I illustrate the users and permissions in the previous paragraph. Slowly you will find in a question: if there is a group of people, their required permissions is the same, when their permissions management time will be very convenient. Because you want to each user of this set of permissions management. A good solution is: role. The role is a set of permissions, the role assigned to a user, the user will have all the permissions in this role. Then the above problem is handled very well, as long as the first role assigned to this group of users, then as long as the role of the management of it. The above is a typical application role. In fact, as long as that set of role is a set