å·¥å
·/åæ
PLSQL
æ¹æ³1
1
åå»è¿è¡PLSQL Developer软件ï¼è¿æ¥oracleæ°æ®åºæå¡å¨
2
å¨â对象âä¸ï¼æ¾å°usersï¼å³å»éæ©âæ°å»ºâ
3
å¨å¼¹åºçâå建ç¨æ·âçªå£ä¸ï¼è¾å
¥æ°ç¨æ·çå称ãå£ä»¤ï¼é»è®¤è¡¨ç©ºé´ã临æ¶è¡¨ç©ºé´ç
4
èµäºæ°ç¨æ·æéï¼èµäºå
¶è§è²æéï¼connectãresourceï¼è¿æ ·ç¨æ·æè½ç»å½æä½æ°æ®åº
END
æ¹æ³2
1
éè¿sqlè¯å¥å建ç¨æ·ï¼ä¾æ¬¡åå»âæ件â--âæ°å»ºâ--âSQLçªå£â
2
è¾å
¥sqlè¯å¥ï¼
-- Create the user
create user USER2 --ç¨æ·å identified by
user2 --å£ä»¤ default tablespace USERS
--é»è®¤è¡¨ç©ºé´ temporary tablespace TEMP --临æ¶è¡¨ç©ºé´
3
åå»æ§è¡æé®ææå¿«æ·é®F8ï¼æ§è¡sqlè¯å¥ï¼å建ç¨æ·
4
è¾å
¥sqlè¯å¥ï¼
-- Grant/Revoke role privileges grant connect to USER2;grant resource to USER2;
ç»ç¨æ·èµäºæéï¼æF8æ§è¡è¯å¥
5
è¿è¡plsqlï¼è¾å
¥æ°å»ºç¨æ·çç¨æ·ååå£ä»¤ç»å½
http://jingyan.baidu.com/article/375c8e1997522e25f2a229c3.html