´«ÖDz¥¿ÍOracleÊÓƵѧϰ±Ê¼Ç

ÊÖ¶¯Æô¶¯Êý¾Ý¿â£º
    Æô¶¯¼àÌý³ÌÐò£ºlsnrctl start
    Æô¶¯Oracle·þÎñ£ºoradim -startup -sid orcl»òÕßnet start oracleserviceorcl 
    ÆäÖÐorclΪÊý¾Ý¿âµÄ·þÎñÃû»òÕßSID£¬oradim -startup -sid orclÕâ¸öÃüÁîÒÔÇ°×Ô¼ºÃ»Óùý
ȨÏÞ¹ÜÀí£º
ϵͳȨÏÞ£º
create user zhangsan identified by zhangsan;
    grant create session to lisi;
    grant create table to lisi;
    grant unlimited tablespace to lisi;
    create table mytable (id int);
    insert into mytable values(1);
    select * from mytable;
    select *  from user_sys_privs;---²éѯµ±Ç°µÇ½Óû§µÄϵͳȨÏÞ
    revoke create table from lisi;
    revoke unlimited tablespace  from lisi;
    grant create any table to public;--ÊÚÓèËùÓÐÓû§
×¢Ò⣺grantÓëtoÊÇÅä¶ÔʹÓõģ¬¶ørevokeÓëfromÅä¶ÔʹÓõÄ
¶ÔÏóȨÏÞ£º
    grant select on tablename to lisi;
    grant  on tablename to lisi;
    revoke all on tablename from lisi;
select * from user_tab_privs;---²éѯµ±Ç°µÇ½Óû§µÄ¶ÔÏóȨÏÞ
disconn ¶Ï¿ªÁ¬½Ó
¶ÔÏóȨÏÞ¿ÉÒÔ¿ØÖƵ½ÁУº
    grant update(name) on mytab to lisi; 
    grant insert(id) on mytab to lisi;
    update wangwu.mytab set name='songyakun',id=1 where id=2;
×¢Ò⣺²éѯºÍɾ³ý²»ÄÜ¿ØÖƵ½ÁУ¬Ö»ÄÜ¿ØÖƵ½ÐÐ
    select * from user_col_privs;---²éѯµ±Ç°µÇ½Óû§µÄÁÐȨÏÞ
ȨÏ޵Ĵ«µÝ£º
    Çл»ÒÔsysµÇ½£º
    grant alter any table to lisi;
    grant alter any table to lisi with admin option;
    grant select on A to lisi with grant option;
    Çл»ÒÔlisiµÇ½:
    grant alter any table to wangwu;
½ÇÉ«¹ÜÀí£º
    create role myrole;
    grant create session to myrole;
  &nbs