°Ë¸öѧϰµã°ïÖúÄãÈ«ÃæÈÏʶOracleÊý¾Ý¿â

TableSpace

     ±í¿Õ¼ä£º Ò»¸ö±í¿Õ¼ä¶ÔÓ¦¶à¸öÊý¾ÝÎļþ(ÎïÀíµÄdbfÎļþ) ÓÃÓï·¨·½Ê½´´½¨tablespace£¬ÓÃsysdbaµÇ½£º --´´½¨±í¿Õ¼ämytabs£¬´óСΪ10MB:

create tablespace mytabs datafile
"C:oracleoradatamydbmytabs1.dbf" size 10M;
alter user zgl default tablespace mytabs;
--°Ñtabs×öΪzglµÄĬÈϱí¿Õ¼ä¡£
grant unlimited tablespace to zgl;
                              --½«²Ù×÷±í¿Õ¼äµÄȨÏÞ¸øzgl¡£

Exception ʾÀý£º
create or replace procedure
pro_test_exception(vid in varchar2) is
userName varchar2(30);
begin
select name into userName from t_user where id=vid;
dbms_output.put_line(userName);
exception
when no_data_found then
dbms_output.put_line("ûÓв鵽Êý¾Ý£¡");
when too_many_rows then
dbms_output.put_line("·µ»ØÁ˶àÐÐÊý¾Ý£¡");
                              end pro_test_exception;

°²È«¹ÜÀí

    ÒÔÏÂÓï¾äÒÔsysdbaµÇ½£º Óû§ÊÚȨ£º alter user zgl account lock;--Ëø¶¨Õʺš£ alter user zgl identified by zgl11;--ÐÞ¸ÄÓû§ÃÜÂë¡£ alter user zgl account unlock;--½â³ýÕʺÅËø¶¨¡£ alter user zgl default tablespace tt;--ÐÞ¸ÄÓû§zglµÄĬÈϱí¿Õ¼äΪtt¡£ create user qqq identified by qqq123 default tablespace tt;--´´½¨Óû§¡£

 grant connect to qqq;--¸øqqqÊÚÓèconnectȨÏÞ¡£ grant execute on zgl.proc01 to test;--½«¹ý³Ìzgl.proc01ÊÚÓèÓû§test¡£ grant create user to zgl;--¸øzglÊÚÓè´´½¨Óû§µÄȨÏÞ¡£ revoke create user from zgl;--½â³ýzgl´´½¨Óû§µÄȨÏÞ¡£

½ÇÉ«ÊÚȨ£º create role myrole;--´´½¨½ÇÉ«myrole grant connect to myrole;--¸ømyroleÊÚÓèconnectȨÏÞ grant select on zgl.t_user to myrole;--°Ñ²éѯzgl.t_userµÄȨÏÞÊÚÓèmyrole grant myrole to test;--°Ñ½ÇÉ«myroleÊÚÓètestÓû§

 ¸ÅÒªÎļþ(ÅäÖÃÎļþ)£º È«¾ÖÉèÖ㬿ÉÒÔÔÚ¸ÅÒªÎļþÖÐÉèÖõǽ´ÎÊý£¬È糬¹ýÕâ´ÎÊý¾ÍËø¶¨Óû§¡£