ORACLEÖеÄdefault role£¬set role
oracleȨÏÞÌåϵÖÐÓиödefault role£¬±È½ÏÄÑÒÔÀí½â¡£ÏÂÃæÓÃʵÀý˵Ã÷Ò»ÏÂ×÷Óá£
ÎÒÃÇ¿ÉÒÔ¸øij¸öÓû§·ÖÅäһЩ½ÇÉ«£¬±ÈÈçrole r1,r2,r3,r4£¬¶øÆäÖпÉÒÔ½«Ä³Ð©½ÇÉ«±ÈÈçr1ÉèÖÃΪdefault role£¬ÆäËûµÄ²»ÉèÖóÉdefault role£¬ÕâÑù£¬µ±¸ÃÓû§µÇ¼ʱ£¬×Ô¶¯¾ßÓÐdefault roleÖÐËù°üº¬µÄȨÏÞ£¬ÆäËûµÄ½ÇÉ«Ëù¾ßÓеÄȨÏÞҪͨ¹ýset role ½ÇÉ«À´»ñµÃ¡£
ÏÂÃæÎÒÃǾٸöÀý×Ó£º
£¨1£©sysÓû§×÷ΪsysdbaµÇ¼£¬´´½¨4¸ö½ÇÉ«£º
create role r1;
create role r2 identified by r2;
create role r3 identified by r3;
create role r4 identified by r4;
£¨2£©sysÓû§¸³ÓèÕâËĸö½ÇÉ«¶ÔÓ¦µÄȨÏÞ£º
grant create session to r1;
grant select on hr.test to r2; £¨ÕâÀïhr.testÊÇÎÒд´½¨µÄÒ»¸ö±í£¬ÀïÃæÓÐIDºÍnameÁ½ÁУ©
grant update(name) on hr.test to r3;
grant insert on hr.test to r3;
grant delete on hr.test to r4;
£¨3£©sysÓû§´´½¨Ò»¸öÓû§u3
create user u3 identified by u3;
£¨4£©½«½ÇÉ«r1,r2,r3,r4¸³ÓèÓû§u3
grant r1,r2,r3,r4 to u3;
ÔÚÐÞ¸ÄÓû§u3µÄĬÈϽÇÉ«Ç°£¬r1,r2,r3,r4 ½ÇÉ«¾ùΪu3µÄ default role£¬ÒÔu3Óû§µÇ¼£¬²éѯ¡¢Ôöɾ¸Ähr.test£¬¶¼Ã»ÓÐÎÊÌâ¡£
£¨5£©ÏÖÔÚsysÓû§ÐÞ¸ÄÓû§u3µÄdefault role£¬½ö½«r1×÷Ϊu3µÄĬÈϽÇÉ«£º
alter user u3 default role r1; --´Ëʱ½«¸²¸ÇÔÀ´µÄÉèÖã¬u3 µÄdefault role =r1£¬½ö½öÓеǼȨÏÞ¡£
£¨6£©Óû§u3 log off £¬È»ºóÔÙlog on£¬½øÈ¥ºó·¢ÏÖ£¬
²éѯ¡¢Ôöɾ¸Ähr.test¶¼²»ÄܽøÐС£
£¨7£© Óû§×Ô¼º´ò¿ªroleȨÏÞ
set role r2 identified by r2;
ÕâʱִÐÐ select * from hr.test,·¢ÏÖûÓÐÎÊÌâ¡£Ôöɾ¸Ä²»ÐС£
½«¶ÔÓ¦µÄ½ÇÉ«´ò¿ª£º
set role r3 identified by r3;
´ËʱÐ޸ĺͲåÈë¼Ç¼ûÓÐÎÊÌ⣬µ«ÊÇselect * from hr.test È··¢ÏÖ²»ÐÐÁË¡£Ö¤Ã÷´ËʱÓû§ËùÊôµÄ½ÇÉ«½ö½öÊÇĬÈϽÇÉ«r1£¬ºÍ¸Õ¸Õ´ò¿ªµÄ½ÇÉ«r3£¬¶ør2±»set role r3 identified by r3;¸²¸ÇµôÁË¡£
ÄÇҪͬʱÓÐr2£¬r3£¬r4µÄȨÏÞÔõô°ìÄØ£¿
set role r2 identified by r2,r3 identified by r3,r4 identified by r4¡£´Ëʱ¾Íͬʱ¶Ôhr.test¿ÉÒÔ½øÐвéѯ£¬Ôöɾ¸ÄÁË¡£
²»¹ýset role µÄЧ¹ûÊÇÁÙʱµÄ£¬Ö»Êǵ±Ç°sessionÓÐЧ£¬ÆäËûµÄsessionÎÞЧ£¬µ±½áÊøµ±Ç°sessionºóÔٵǼ£¬ÓÖÖ»ÓÐdefault role µÄȨÏÞÁË¡£
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
2009Äê9ÔÂOracle¹«Ë¾·¢²¼ÁËÆÚ´ýÒѾõÄOracle 11g R2£¬±¾ÏµÁÐÎÄÕ½«¸ø¶ÁÕßÒ»Ò»½Ò¿ªÐ°汾ÖеÄÐÂÌØÐÔ£¬²¢»á½éÉÜÆóÒµÈçºÎÀûÓÃÕâЩÐÂÌØÐÔ½«ÏÖÓеÄOracle 9i£¬10g£¬11g R1Éý¼¶µ½Oracle 11g R2.
¡¡¡¡¾ÀúÁËÄÑÒÔÈÌÊܵij¤Ê±¼äµÈ´ý£¬Oracle¹«Ë¾Í»È»ÔÚ9ÔÂ1·¢²¼ÁËOracle 11g R2£¬ÎÒ²»µÃ²»³ÐÈÏOracleµÄ±£Ãܹ¤×÷×öµÃ¶àôºÃ£¬ÎÒÏàÐÅOracl ......
1,<>
2,µ¥¶ÀµÄ>,<,(ÓÐʱ»áÓõ½£¬ÓÐʱ²»»á)
3,like "%_" °Ù·ÖºÅÔÚÇ°.
4,±íû·ÖÎö.
5,µ¥¶ÀÒýÓø´ºÏË÷ÒýÀï·ÇµÚһλÖõÄË÷ÒýÁÐ.
6,×Ö·ûÐÍ×Ö¶ÎΪÊý×ÖʱÔÚwhereÌõ¼þÀï²»Ìí¼ÓÒýºÅ.
7,¶ÔË÷ÒýÁнøÐÐÔËËã.ÐèÒª½¨Á¢º¯ÊýË÷Òý.
8,not in ,not exist.
9,µ±±äÁ¿²ÉÓõÄÊÇtimes±äÁ¿£¬¶ø±íµÄ×ֶβÉÓõÄÊÇdate±äÁ¿Ê±.»òÏà· ......
½ñÌìÔÚ¿ª·¢µÄʱºòÐèÒª²éѯÊý¾Ý¿âÖÐÄÄЩѧÉúÓжà¸öѧºÅ£¬Ð´µÄsqlÈçÏ£º
select * from(
select count(t1.xh) as xhs,t2.uuid,t3.xm as xsxm,t3.sfzjh, t1.xjzt as xjzt from hust_xs_jb t1
INNER JOIN hust_xx_identity t2 on t1.sfid ......
####################################
# TNSNAMES.ORA Configuration File:D:\Oracle_now\NETWORK\ADMIN\tnsnames.ora ÎļþλÖÃ
# Generated by Oracle Enterprise Manager V2
# Date..........: Tue Jan 26 20:05:00 CST 2010
####################################
TEST1.TCSGEGDC.COM =
(DESCRIPTION =
& ......