蟯襴 一危 覲危語 蠍磯蓋 .. 一危覯伎 覯
蟯襴 覦 蟯 螳讌螻 給.
覲企ゼ 蟲 讓曙 願鍵 覓語 蟯襴襯 覓企 譴 ..
覲危 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 蟾讌 る 伎..