[ת]Oracle½ÇÉ«¡¢È¨ÏÞ
OracleÄÚÖýÇÉ«connectÓëresourceµÄȨÏÞ
============================================================
Ò»¡¢ºÎΪ½ÇÉ«£¿
¡¡¡¡Èç¹ûÓÐÒ»×éÈË£¬ËûÃǵÄËùÐèµÄȨÏÞÊÇÒ»ÑùµÄ£¬¶ÔËûÃǵÄȨÏÞ½øÐйÜÀíµÄʱºò»á²»·½±ã¡£ÒòΪÄãÒª¶ÔÕâ×éÖеÄÿ¸öÓû§µÄȨÏÞ¶¼½øÐйÜÀí¡£
¡¡¡¡ÓÐÒ»¸öºÜºÃµÄ½â¾ö°ì·¨¾ÍÊÇ£º½ÇÉ«¡£½ÇÉ«ÊÇÒ»×éȨÏ޵ļ¯ºÏ£¬½«½ÇÉ«¸³¸øÒ»¸öÓû§£¬Õâ¸öÓû§¾ÍÓµÓÐÁËÕâ¸ö½ÇÉ«ÖеÄËùÓÐȨÏÞ¡£ÄÇôÉÏÊöÎÊÌâ¾ÍºÜºÃ´¦ÀíÁË£¬Ö»ÒªµÚÒ»´Î½«½ÇÉ«¸³¸øÕâÒ»×éÓû§£¬½ÓÏÂÀ´¾ÍÖ»ÒªÕë¶Ô½ÇÉ«½øÐйÜÀí¾Í¿ÉÒÔÁË¡£ Æäʵ£º½ÇÉ«¾ÍÊÇÒ»×éȨÏ޵ļ¯ºÏ¡£ÏÂÃæ·ÖÁ½¸ö²¿·ÖÀ´¶Ôoracle½ÇÉ«½øÐÐ˵Ã÷¡£
============================================================
¶þ¡¢ÏµÍ³Ô¤¶¨Òå½ÇÉ«
¡¡¡¡Ô¤¶¨Òå½ÇÉ«ÊÇÔÚÊý¾Ý¿â°²×°ºó£¬ÏµÍ³×Ô¶¯´´½¨µÄһЩ³£ÓõĽÇÉ«¡£Ï½é¼òµ¥µÄ½éÉÜÒ»ÏÂÕâЩԤ¶¨½ÇÉ«¡£½ÇÉ«Ëù°üº¬µÄȨÏÞ¿ÉÒÔÓÃÒÔÏÂÓï¾ä²éѯ£º
sql>select * from role_sys_privs where role='½ÇÉ«Ãû'; (×¢Òâ:ÕâÀïµÄROLE¾¹ýϵͳ×Ô¶¯×ª»¯Îª´óд,²éѯµÄʱºòÒª´óд)
»òÕß
select grantee,privilege from dba_sys_privs
where grantee = '½ÇÉ«Ãû' order by privilege;
¾ÙÀý:²é¿´RESOURCE½ÇÉ«µÄȨÏÞ
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
¸³ÓèuserÓû§connect½ÇÉ«ºÍresource½ÇÉ«£º
grant connect,resource to user;
ÔËÐгɹ¦ºóÓû§°üÀ¨µÄȨÏÞ:
CONNECT½ÇÉ«£º --ÊÇÊÚÓè×îÖÕÓû§µÄµäÐÍȨÀû£¬×î»ù±¾µÄ
ALTER SESSION --Ð޸ĻỰ
CREATE CLUSTER --½¨Á¢¾Û´Ø
CREATE DATABASE LINK --½¨Á¢Êý¾Ý¿âÁ´½Ó
CREATE SEQUENCE --½¨Á¢ÐòÁÐ
CREATE SESSION --½¨Á¢»á»°
CREATE SYNONYM --½¨Á¢Í¬Òå´Ê
CREATE VIEW --½¨Á¢ÊÓͼ
RESOURCE ½ÇÉ«£º --ÊÇÊÚÓ迪·¢ÈËÔ±µÄ
CREATE CLUSTER --½¨Á¢¾Û´Ø
CREATE PROCEDURE --½¨Á¢¹ý³Ì
CREATE SEQUENCE --½¨Á¢ÐòÁÐ
CREATE TABLE --½¨±í
Ïà¹ØÎĵµ£º
½ñÌ츴ϰOracleµÄÊý¾Ý×ÖµäºÍ¿ØÖÆÎļþ¡£
Ò»¡¢Êý¾Ý×Öµä
Êý¾Ý×ÖµäÊÇÓÉOracle·þÎñÆ÷´´½¨ºÍά»¤µÄÒ»×éÖ»¶ÁµÄϵͳ±í£¬Êý¾Ý×Öµä·ÖΪÁ½´óÀࣺһÀàΪ»ù±í£¬Ò»ÀàΪÊý¾Ý×ÖµäÊÓͼ¡£ÄÇôÊý¾Ý×ÖµäÖÐÓÖ´æÓÐÄÄЩÐÅÏ¢ÄØ£¿
1¡¢Êý¾Ý¿âµÄÂß¼½á¹¹ºÍÎïÀí½á¹¹
2¡¢ËùÓÐÊý¾Ý¿â¶Ô ......
1¡¢²é¿´±í¿Õ¼äµÄÃû³Æ¼°´óС
select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size
from dba_tablespaces t, dba_data_files d
where t.tablespace_name = d.tablespace_name
group by t.tablespace_name;
2¡¢²é¿´±í¿Õ¼äÎïÀíÎļþµÄÃû³Æ¼°´óС
select tablespace_name, file_id, file_name,
round(by ......
ORACLEºÍSQLÓï·¨Çø±ð¹éÄÉ
Êý¾ÝÀàÐͱȽÏ
ÀàÐÍÃû³Æ
Oracle
SQLServer
±È½Ï
×Ö·ûÊý¾ÝÀàÐÍ CHAR CHAR ¶¼Êǹ̶¨³¤¶È×Ö·û×ÊÁϵ«oracleÀïÃæ×î´ó¶ÈΪ2kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
±ä³¤×Ö·ûÊý¾ÝÀàÐÍ VARCHAR2 VARCHAR OracleÀïÃæ×î´ó³¤¶ÈΪ4kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´® NCHAR NCHA ......
ÔÚ´óÐÍÊý¾Ý¿âÖУ¬Ò»·½ÃæÊý¾Ý¿âÒªÌṩ¸ß²¢·¢·ÃÎʵÄÄÜÁ¦£¬ÓÖÒª±£Ö¤Ã¿Ò»¸öÓû§ÒÔÒ»Öµķ½Ê½·ÃÎʺÍÐÞ¸ÄÊý¾Ý¡£Ëø»úÖÆ¾ÍÊÇÓÃÀ´½â¾öÕâÒ»ÎÊÌ⣬ÓÃÓÚ¿ØÖƶԹ²Ïí×ÊÔ´µÄ²¢·¢·ÃÎÊ£¬±£Ö¤Êý¾Ý·ÃÎʵÄÒ»ÖÂÐÔºÍ׼ȷÐÔ¡£
ÔÚoracleÖУ ......
ÊÕ¼¯Ò»Ð©Oracle¿ª·¢ÓëʹÓÃÎÄÕÂ,ÒÔ±ãÓÚºóÐø²éÕÒ.
¡¾»ù´¡Àà¡¿
1.ORACLEº¯Êý´óÈ«
2.Orace³£Óú¯Êý
3.oracle ÈÕÆÚº¯Êý½éÉÜ
4.OracleÖг£ÓõÄto_CharÓ÷¨Ïê½â£¨ÓÐFMTµÄÏêϸÁÐ±í£©
5.ORACLEÖÐÈÕÆÚºÍʱ¼äº¯Êý»ã×Ü(×ªÔØ)
6.SQL ServerºÍOracle³£Óú¯Êý¶Ô±È
7.Oracleº¯ÊýÏê½â
8.Oracle ·ÖÎöº¯ÊýµÄʹÓÃ
9.Oracle for ......