_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁 |
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 蟾讌 る 伎..
鏤
|
蟆壱殊 伎手鍵れ 螻 蠍願鹸 伎手鍵. (殊) |