ÍæתOracle£¨2£©

sql*plus ÃüÁî
//Ö´Ðнű¾
@ºÍstart d:/a.txt;
//Ð޸Ľű¾
edit d:/a.txt;
//½«ÄÚÈÝÊäÈëµ½Îı¾ÖÐ
sloop d:/a.txt;  //¿ªÊ¼¼Ç¼ÆÁÄ»ÄÚÈÝ
sloop off;  //¼Ç¼½áÊø
//Á´½ÓµÇ¼Êý¾Ý¿â
connect system/919959 as sysdba/sysoper;  //ȨÏÞ×î´ódba
connect sys/919959;
connect scott/tiger;
//´´½¨Óû§
create user valen identified by 919959;  //´´½¨Íê³Éºó²¢²»Äܹ»µÇ¼£¬ÐèÒªÊÚȨ
//µ±Ç°Óû§
show user;
//ɾ³ýÓû§
drop user valen;
//ÊÚȨ
grant connect to valen;  //µÇ¼µÄȨÏÞ
grant resource to valen; //½¨±íµÄȨÏÞ
grant select on emp to valen; //½«¶ÔÏó²Ù×÷ȨÏÞ¸øÓèijһ¸öÓû§£¬¼ÙÉ赱ǰÓû§Îªscott£¬½«scottµÄemp±íµÄselectȨÏÞ¸³¸øvalen
grant update on emp  //¸üÐÂȨÏÞ
grant inset on emp  //Ìí¼ÓȨÏÞ
grant delete on emp  //ɾ³ýȨÏÞ
grant all on emp  //µ±Ç°±íµÄËùÓÐȨÏÞ
//ÊÕ»ØȨÏÞ
revoke select on emp from valen; //´ÓvalenÓû§ÊջضÔemp±íµÄselectȨÏÞ
//²éѯÆäËûÓû§µÄ±íµÄȨÏÞ
select * from scott.emp  //²éѯscottÓû§ÏÂemp±í
//ȨÏÞµÄά»¤
//¶ÔÏóȨÏÞ
scott½«È¨ÏÞ´«¸øÁËvalen£¬²¢Ï£Íûvalen½«¸ÃÑ¡Ïß¼ÌÐø´«µÝ¸øÏÂÒ»¸öÓû§
grant select on emp to valen with grant option //Èç¹ûÊǶÔÏóȨÏ޾ͼÓÈëwith grant option
//ϵͳȨÏÞ
grant connect to valen with admin option //Èç¹ûÊÇϵͳȨÏ޾ͼÓÈëwith admin option
Èç¹ûscottÊÕ»ØÁËvalenµÄȨÏÞ£¬ÔòvalenÊÚȨ¸øtomµÄȨÏÞÒ²±»ÊÕ»ØÁË
//ʹÓÃprofile¹ÜÀíÓû§¿ÚÁî
´´½¨profileÎļþ
create profile lock_account //´´½¨¹æÔòlock_account
limit    //¹Ø¼ü×Ö
failed_login_attempts 3  //¸øÓè3´ÎµÇ¼»ú»á
password_lock_time 2;  //Ëø¶¨2Ìì
//¸ü¸ÄÓû§×ñÑ­´Ë¹æÔò
alter user tom profile lock_account;
//¸øÕË»§½â·â
alter user tom account unlock; //¸øÖ¸¶¨Óû§½â·â
//ÖÕÖ¹¿ÚÁî
create profile myprofile //´´½¨¹æÔòmyprofile
limit
password_life_time 10  //ÿ10ÌìÐ޸ĵǼÃÜÂë
password_grace_time 2  //¿íÏÞÆÚΪ2Ìì
password_reuse_time 10  //Ö¸¶¨¿ÚÁî¿ÉÖØÓÃʱ¼ä¼´10Ììºó¾Í¿ÉÒÔÖØÓÃ
//