Oracle ÕʺŻù±¾¹ÜÀí

1. Oracle°²×°Íê³ÉºóµÄÓû§ÃûºÍÃÜÂë
sys/change_on_install
system/manager
scott/tiger
sysman/oem_temp
internal/oracle
 
2.ÐÞ¸ÄÓû§µÄÃÜÂë
SQL> conn sys/change_on_install as sysdba
Connected.
SQL> alter user sys identified by ******;
User altered.
 
3.ΪÓû§½âËø
SQL> conn scott/tiger
ERROR:
ORA-28000: the account is locked
Warning: You are no longer connected to ORACLE.
SQL>conn sys/change_on_install as sysdba
Connected.
SQL> alter user scott account unlock;
User altered.
 
Ëø¶¨Óû§£º
SQL> alter user scott account lock;
 
4.²é¿´ËùÓÐÓû§£º
  select * from dba_users;
  select * from all_users;
  select * from user_users;
5.²é¿´Óû§»ò½ÇɫϵͳȨÏÞ£º
  select * from dba_sys_privs;
  select * from user_sys_privs;
6.²é¿´Óû§¶ÔÏóȨÏÞ£º
  select * from dba_tab_privs;
  select * from all_tab_privs;
  select * from user_tab_privs;
7..²é¿´ËùÓнÇÉ«£º
  select * from dba_roles;
8.²é¿´Óû§»ò½ÇÉ«ËùÓµÓеĽÇÉ«£º
  select * from dba_role_privs;
  select * from user_role_privs;
 
9.´´½¨Óû§
SQL> create user kevin identified by password
2 default tablespace users
3 temporary tablespace temp
4 quota 10M on users;
User created.
SQL> conn kevin/password
ERROR:
ORA-01045: user KEVIN lacks CREATE SESSION privilege; logon denied
SQL> grant create session to kevin;  //ÊÚȨÓû§¿ÉÒÔÁ¬½ÓÊý¾Ý¿â
Grant succeeded.
 
10.ÊÚȨÓû§connectºÍresource½ÇÉ«
SQL> grant connect to kevin; 
Grant succeeded.
SQL> grant resource to kevin;
Grant succeeded.
SQL> grant connect,resource to kevin;
Grant succeeded.
 
11.²é¿´connectºÍresourceµÄȨÏÞ
SQL> select * from dba_sys_privs where grantee='CONNECT';
GRANTEE                        PRIVILEGE          &