_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › 蟯襴蠍磯蓋
Describe 蟯襴蠍磯蓋 here

蟯襴 一危 覲危語  蠍磯蓋 .. 一危覯伎 覯
 蟯襴 覦 蟯 螳讌螻 給. 

覲企ゼ 蟲 讓曙 願鍵 覓語 蟯襴襯 覓企 譴 ..
 覲危 SQL*Plus朱 伎 伎 ..覓朱 轟 危襴貅伎
牛伎 蠍磯 ..

朱...SQL*Plus 蠍壱 危襴貅伎 牛  襯 企殊伎誤碁手 讌..
 譯?? ~

襾殊 る狩伎 れ覃 蠍磯蓋  

SYS/CHANGE_ON_INSTALL
SYSTEM/MANAGER
SCOTT/TIGER
HR/HR

.. る狩 9i 覯覿磯 れ 螻殊 る狩   蠍磯蓋 
襯 螻豺  覿覿 譟伎.. 蠍一 /れ  蟆 蠍磯蓋 れ
..

轟 る狩伎 れ螻  企至 伎狩讌 覈磯殊 讌覓語  覿れ 
給..企 覿れ 覓 炎 覿れ...蟇一 覈 る狩  
蠍磯蓋  蠏語 磯ジ れ襯 覈螻 給...る狩 れ 
蟲.. 豌 覈磯殊 谿 螻給..~ 覦覿螳譯襾..

..蠍磯蓋 碁  覈覦 螳給..蠍一 SYS, SYSTEM  
れ襯 螻豎譴 ..襷 れ 螻殊譴...蟆 一危覯伎るゼ 
 螻殊譴 れ襯 螻豺讌 殊 覿れ 覦 螻豎譴 ..

SYS, SYSTEM 襷蟠(SYSTEM  る狩伎 蠍磯/譬襭 襷 螻, 襷蟠)
 螳讌螻 蠍 覓語 伎  碁ゼ 螻豺讌 朱 覓企   蠍 覓語
一危 れ 磯り 讌...
朱 螻豺讌 殊 覿れ 螻豎譯殊語..

覓碁 れ螻 螳給..

ALTER USER 覈
IDENTIFIED BY 覦蠖;


SQL> ALTER USER SYSTEM IDENTIFIED BY MANAGER;

螳 覲蟆暑給.

SQL> ALTER USER SYS IDENTIFIED BY CHANGE_ON_INSTALL;

螳 覲蟆暑給.

 蠏碁 蠍一ヾ 碁 れ 覦蠑 蟆..覿 るゴ蟆 螻豎譯殊蠍 覦..

朱  蟯襴 , 蟠, , リ規譟一  4螳讌 螻るゼ 伎殊伎 .
襾殊 蠍磯蓋  炎骸 覲蟆曙  蟆 覲企襦 蟆給.
れ る狩  煙  覓碁..

CREATE USER user IDENTIFIED 
{ BY password | EXTERNALLY | GLOBALLY AS 'external_name' }
[{ DEFAULT TABLESPACE tablespace
 | TEMPORARY TABLESPACE tablespace
 | QUOTA { integer [ K | M ] | UNLIMITED } ON tablespace 
   [QUOTA { integer [ K | M ] | UNLIMITED } ON tablespace]...
 | PROFILE profile
 | PASSWORD EXPIRE
 | ACCOUNT { LOCK | UNLOCK }
 }
 [ DEFAULT TABLESPACE tablespace
 | TEMPORARY TABLESPACE tablespace
 | QUOTA { integer [ K | M ] | UNLIMITED } ON tablespace 
   [QUOTA { integer [ K | M ] | UNLIMITED } ON tablespace]...
 | PROFILE profile
 | PASSWORD EXPIRE
 | ACCOUNT { LOCK | UNLOCK }
 ]...
]
;

譟碁 襷給...~ 覲願鍵襷 企 讌蟆轟?? 蠏朱..譟郁  覲企 蟷 .
蟇   蟆 蟲... 磯殊 磯企 蟆..れ 企..
覈磯朱 朱 磯狩 覺...


SQL> CREATE USER YASI 
  2  IDENTIFIED BY YASI;

螳 焔給.

SQL> CONNECT YASI/YASI;
ERROR:
ORA-01045: user YASI lacks CREATE SESSION privilege; logon denied


蟆所: 伎 ORACLE 郁屋 讌 給.
SQL> CONNECT SYSTEM/MANAGER
郁屋給.
SQL> GRANT CREATE SESSION TO YASI;

蟠 覿給.

SQL> CONNECT YASI/YASI
郁屋給.
SQL> 


譴螳 燕 襦 郁屋 朱 ろ 蟆 覲伎..
願 襯 燕朱 蠏 螳 語 伎  蟠 蠍 覓語 郁屋
ろ 蟆..

企 覿れ 覓碁 譟碁朱 れ   豺  蟆  覓語
螳讌 給..牛 蟆れ  蟆 る狩伎 蠍磯蓋螳 伎 襦 れ願..

..朱   ->  蟾讌 炎概給..蠍一 蟠 蟯  
 る 蟲一... 蟠螻 蟯 一危 觀磯 れ螻 螳給...


SQL> CONNECT SYS/CHANGE_ON_INSTALL AS SYSDBA;
郁屋給.
SQL> SELECT TNAME FROM TAB
  2  WHERE TNAME LIKE '%PRIV%';

TNAME
------------------------------------------------------------
ALL_COL_PRIVS
ALL_COL_PRIVS_MADE
ALL_COL_PRIVS_RECD
ALL_REPGROUP_PRIVILEGES
ALL_TAB_PRIVS
ALL_TAB_PRIVS_MADE
ALL_TAB_PRIVS_RECD
COLUMN_PRIVILEGES
DBA_AQ_AGENT_PRIVS
DBA_COL_PRIVS
DBA_PRIV_AUDIT_OPTS
DBA_REPGROUP_PRIVILEGES
DBA_ROLE_PRIVS
DBA_RSRC_CONSUMER_GROUP_PRIVS
DBA_RSRC_MANAGER_SYSTEM_PRIVS
DBA_SYS_PRIVS
DBA_TAB_PRIVS
GV_$ENABLEDPRIVS
OBJPRIV$
QUEUE_PRIVILEGES
ROLE_ROLE_PRIVS
ROLE_SYS_PRIVS
ROLE_TAB_PRIVS
SESSION_PRIVS
SYSTEM_PRIVILEGE_MAP
TABLE_PRIVILEGES
TABLE_PRIVILEGE_MAP
USER_AQ_AGENT_PRIVS
USER_COL_PRIVS
USER_COL_PRIVS_MADE
USER_COL_PRIVS_RECD
USER_REPGROUP_PRIVILEGES
USER_ROLE_PRIVS
USER_RSRC_CONSUMER_GROUP_PRIVS
USER_RSRC_MANAGER_SYSTEM_PRIVS
USER_SYS_PRIVS
USER_TAB_PRIVS
USER_TAB_PRIVS_MADE
USER_TAB_PRIVS_RECD
V_$ENABLEDPRIVS

40 螳  給.

SQL> SLEECT * FROM DBA_SYS_PRIVS;

                   .
                   .
                   .
              襷 ..<;;;

SQL> CONNECT YASI/YASI;
郁屋給.                                          
SQL> COL USERNAME FORMAT A20
SQL> COL PRIVILEGE FORMAT A20
SQL> SELECT * FROM USER_SYS_PRIVS;

USERNAME             PRIVILEGE            ADMIN_
-------------------- -------------------- ------
YASI                 CREATE SESSION       NO

SQL>                


..企給...蟠 螳豌願螻 ろ 蟠 給..  襷
る蟇 譯? 蠏瑚 ろ 蟠...願碓 殊殊  伎手 朱 襾碁Μ 蟆
 覈 蟆願  讌讀 襷 蟆譯??
蠏碁 蠍願 襦れ企朱 蟆...讀, 蟠 覓苦伎  蟆..螳 
襷れ 螻..る狩伎 螻牛 蟆 給..

企 覿覿 伎 譴 誤 覲企襦 蟲...朱 譴 襦 2螳襯 
覲願給...譴 2螳 CONNECT, RESOURCE 襦れ..


SQL> COL GRANTEE FORMAT A15
SQL> SELECT * FROM DBA_SYS_PRIVS
  2  WHERE GRANTEE IN ('CONNECT', 'RESOURCE');

GRANTEE         PRIVILEGE            ADMIN_
--------------- -------------------- ------
CONNECT         CREATE VIEW          NO
CONNECT         CREATE TABLE         NO
CONNECT         ALTER SESSION        NO
CONNECT         CREATE CLUSTER       NO
CONNECT         CREATE SESSION       NO
CONNECT         CREATE SYNONYM       NO
CONNECT         CREATE SEQUENCE      NO
CONNECT         CREATE DATABASE LINK NO
RESOURCE        CREATE TYPE          NO
RESOURCE        CREATE TABLE         NO
RESOURCE        CREATE CLUSTER       NO
RESOURCE        CREATE TRIGGER       NO
RESOURCE        CREATE OPERATOR      NO
RESOURCE        CREATE SEQUENCE      NO
RESOURCE        CREATE INDEXTYPE     NO
RESOURCE        CREATE PROCEDURE     NO

16 螳  給.


螳 襦れ 8螳 蟠 螳讌螻  蟆 覲伎..讀,  蟲覓語 
る 蟆..

企骸蟾??

SQL> CONNECT YASI/YASI
郁屋給.
SQL> CREATE TABLE TEST(
  2  ID NUMBER,
  3  NAME VARCHAR2(10));
CREATE TABLE TEST(
*
1 る:
ORA-01031: 蟠 覿豢覿


SQL> CONNECT SYSTEM/MANAGER
郁屋給.
SQL> GRANT CONNECT TO YASI;

蟠 覿給.

SQL> CONNECT YASI/YASI;
郁屋給.
SQL> CREATE TABLE TEST(
  2  ID NUMBER,
  3  NAME VARCHAR2(10));
CREATE TABLE TEST(
*
1 る:
ORA-01950: 企  'SYSTEM'  蟠 

SQL> CONNECT SYSTEM/MANAGER
郁屋給.
SQL> GRANT RESOURCE TO YASI;

蟠 覿給.

SQL> CONNECT YASI/YASI
郁屋給.
SQL> CREATE TABLE TEST(
  2  ID NUMBER,
  3  NAME VARCHAR2(10));

企 焔給.

SQL> 


   DROP USER 覓語 ..
覓碁 れ螻 螳給..

DROP USER user [CASCADE];


SQL> CONNECT SYSTEM/MANAGER
郁屋給.
SQL> DROP USER YASI;
DROP USER YASI
*
1 る:
ORA-01922: 'YASI'()襯 る CASCADE襯 讌 


SQL> DROP USER YASI 
  2  CASCADE;


る 企 YASI 螳 燕() 螳豌願 譟伎蠍 覓語 企ゼ
企至 伎狩讌 覈襯企 る狩伎 る覃語襯 襴危 蟆..
蠍一 襷 螳豌企 TEST 企..蠏碁 CASCADE 旧 譯殊伎 YASI 螳
 企, 碁煙 煙 螳豌企ゼ 覈 螳 讌企る 蟆 襷 蟆.

伎..る 蠍磯蓋  覈螳讌襷  覲願規...れ朱 蟆 蟆企..
...襾語  煙  蟆れ...

DEFALUT TABLESPACE
TEMPORARY TABLESPACE
QUATO

蠍磯蓋朱  旧 覿譯殊 朱  SYSTEM 企ろ伎るゼ 蟆
. 蠏碁覃 螳讌  ...  覿覿 譴 覲企襦 蟲...
朱...企..


SQL> CONNECT SYSTEM/MANAGER
郁屋給.
SQL> DROP USER YASI CASCADE;

螳 給.

SQL> SELECT TABLESPACE_NAME FROM DBA_TABLESPACES;

TABLESPACE_NAME
------------------------------------------------------------
SYSTEM
UNDOTBS1
TEMP
CWMLITE
DRSYS
EXAMPLE
INDX
ODM
TOOLS
USERS
XDB

11 螳  給.

SQL> CREATE USER YASI IDENTIFIED BY YASI
  2  DEFAULT TABLESPACE USERS
  3  TEMPORARY TABLESPACE TEMP
  4  QUOTA 5M ON USERS;

螳 焔給.

SQL> GRANT CONNECT, RESOURCE TO YASI;

蟠 覿給.

SQL> 



蠍磯蓋朱 YASI 螳  企ろ伎る USERS願 煙 
 企ろ伎る TEMP 企ろ伎り, 蠏碁れ USERS  企ろ伎るゼ
5M 蟾讌   る 伎..



蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:53

讌襦 企 螳 覿覈 覈 手鬼企. (覈渚)