Oracle´óÈ«

Oracle Óû§¼°½ÇÉ« ½éÉÜ ÊÕ²Ø
Ò». Óû§¹ÜÀí
1.1 ½¨Á¢Óû§£¨Êý¾Ý¿âÑéÖ¤£©
     CREATE  USER   DAVE  IDENTIFIED  BY   pwd
     DEFAULT TABLESPACE  users
     TEMPORARY   TABLESPACE  temp
     QUOTA  5m  ON  users;
1.2 ÐÞ¸ÄÓû§
ALTER USER DAVE QUOTA 0 ON SYSTEM;
1.3 ɾ³ýÓû§
DROP USER DAVE;
DROP USER DAVE CASCADE;
1.4 ÏÔʾÓû§ÐÅÏ¢
SELECT * from DBA_USERS
SELECT * from DBA_TS_QUOTAS
¶þ.ϵͳȨÏÞ
ϵͳȨÏÞ
 ×÷ÓÃ
 
CREATE SESSION
 Á¬½Óµ½Êý¾Ý¿â
 
CREATE TABLE
 ½¨±í
 
CREATE TABLESPACE
 ½¨Á¢±í¿Õ¼ä
 
CREATE VIEW
 ½¨Á¢ÊÓͼ
 
CREATE SEQUENCE
 ½¨Á¢ÐòÁÐ
 
CREATE USER
 ½¨Á¢Óû§
 
 
ϵͳȨÏÞÊÇÖ¸Ö´ÐÐÌض¨ÀàÐÍSQLÃüÁîµÄȨÀû£¬ÓÃÓÚ¿ØÖÆÓû§¿ÉÒÔÖ´ÐеÄÒ»¸ö»òÒ»ÀàÊý¾Ý¿â²Ù×÷¡££¨Ð½¨Óû§Ã»ÓÐÈκÎȨÏÞ£©
2.1 ÊÚÓèϵͳȨÏÞ
GRANT CREATE SESSION,CREATE TABLE TO DAVE;
GRANT CREATE SESSION TO DAVE WITH ADMIN OPTION;
Ñ¡ÏADMIN OPTION ʹ¸ÃÓû§¾ßÓÐתÊÚϵͳȨÏÞµÄȨÏÞ¡£
2.2 ÏÔʾϵͳȨÏÞ
²é¿´ËùÓÐϵͳȨÏÞ£º
Select * from system_privilege_map;
ÏÔʾÓû§Ëù¾ßÓеÄϵͳȨÏÞ£º
Select * from dba_sys_privis;
ÏÔʾµ±Ç°Óû§Ëù¾ßÓеÄϵͳȨÏÞ£º
Select * from user_sys_privis;
ÏÔʾµ±Ç°»á»°Ëù¾ßÓеÄϵͳȨÏÞ£º
Select * from session_privis;
2.3 ÊÕ»ØϵͳȨÏÞ
REVOKE CREATE TABLE from DAVE;
REVOKE CREATE SESSION from DAVE;
Èý .½ÇÉ«£º
½ÇÉ«ÊÇÒ»×éÏà¹ØȨÏÞµÄÃüÃû¼¯ºÏ£¬Ê¹ÓýÇÉ«×îÖ÷ÒªµÄÄ¿µÄÊǼò»¯È¨ÏÞ¹ÜÀí¡£
3.1 Ô¤¶¨Òå½ÇÉ«¡£
CONNECT×Ô¶¯½¨Á¢£¬°üº¬ÒÔÏÂȨÏÞ£ºALTER SESSION¡¢CREATE CLUSTER¡¢CREATE DATABASELINK¡¢CREATE SEQUENCE¡¢CREATE SESSION¡¢CREATE SYNONYM¡¢CREATE TABLE¡¢CREATEVIEW¡£
RESOURCE×Ô¶¯½¨Á¢£¬°üº¬ÒÔÏÂȨÏÞ£ºCREATE CLUSTER¡¢CREATE PROCEDURE¡¢CREATE SEQUENCE¡¢CREATE TABLE¡¢CREATE TRIGGR¡£
3.2 ÏÔʾ½ÇÉ«ÐÅÏ¢£¬
§ROLE_SYS_PRIVS
§ROLE_TAB_PRIVS
§ROLE_ROLE_PRIVS
§SESSION_ROLES
§USER_ROLE_PRIVS
§DBA_ROLES
ËÄ. OracleÓû§½ÇÉ«
ÿ¸öOra