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
Ïà¹ØÎĵµ£º
-- ²éѯÍâ¼üÔ¼Êø(²éij±íµÄËùÓи¸±í)
select c.constraint_name,cc.column_name,rcc.owner,rcc.table_name,rcc.column_name
from user_constraints c,user_cons_columns cc,user_cons_columns rcc
where c.owner=' ......
ÏîÄ¿¾ÀíÈÃ×öÀúÊ·Êý¾Ý±¸·Ý£¬Éæ¼°µ½ÈçºÎ½«ÒµÎñ±íÖеļǼµ¼³öµ½ÀúÊ·±íÖУ¬×Ô¼º×ʼÏëÄѵÀÊǸú×Ô¶¯¶ÔÕ˺Í×Ô¶¯ÉÏ´«³ÌÐòÒ»Ñùд¸ö³ÌÐòÈ»ºó½«³ÌÐò·ÅÔÚϵͳµÄÈÎÎñ¼Æ»®ÀﶨʱÔËÐУ¿»¹ÊÇÎÊÎÊÏîÄ¿¾Àí°É£¬ÎÊÏîÄ¿¾Àí£¬Äǵ¼³ö¼Ç¼Ôõô×ö¡£ÏîÄ¿¾Àí˵£¬Êý¾Ý¿âÀïÓ¦¸ÃÓÐÕâ¸ö¹¦ÄÜ°É¡£»ÐÈ»´óÎò£¬ÒþÔ¼¼ÇµÃÖ ......
ÔÚÒ»±íorginfoÉϽ¨Á¢´¥·¢Æ÷£¬ÆäÖаüÀ¨ÒÔ϶¯×÷£º
Ôöɾ¸Ä´Ë±íµÄ¼Ç¼ʱ£¬ÐèÒª²éѯ´Ë±í£¬ÉõÖÁ¸Äд´Ë±íµÄÆäËû¼Ç¼¡£±¨¸æ“ora-04091:±íÒѾ±»Ð޸ģ¬¶ÔÓÚ´¥·¢Æ÷/º¯Êý²»¿É¼û”¡£
Cause: A trigger (or a user defined PL/SQL function that is referenced in this statement) attempted to look at (or modify) a tab ......
µÇ¼oracleÊý¾Ý¿âʱ³£ÓõIJÙ×÷ÃüÁîÕûÀí
1¡¢su – oracle ²»ÊDZØÐ裬ÊʺÏÓÚûÓÐDBAÃÜÂëʱʹÓ㬿ÉÒÔ²»ÓÃÃÜÂëÀ´½øÈësqlplus½çÃæ¡£
2¡¢sqlplus /nolog »òsqlplus system/manager »ò./sqlplus system/manager@ora9i
;
3¡¢SQL>connect / as sysdba ;£¨as sysoper£©»ò
connect internal/oracle AS SYSDBA ;(scott/ti ......
Mysql£¬SqlServer£¬OracleÖ÷¼ü×Ô¶¯Ôö³¤µÄÉèÖÃ
1¡¢°ÑÖ÷¼ü¶¨ÒåΪ×Ô¶¯Ôö³¤±êʶ·ûÀàÐÍ
ÔÚmysqlÖУ¬Èç¹û°Ñ±íµÄÖ÷¼üÉèΪauto_incrementÀàÐÍ£¬Êý¾Ý¿â¾Í»á×Ô¶¯ÎªÖ÷¼ü¸³Öµ¡£ÀýÈ磺
create table customers(id int auto_increment primary key not null, name varchar(15));
insert into customers(name) values("name1"),("nam ......