æè¿æ个ææ¬ææ¡£ï¼å¦æä½ æ³è¦ï¼è¯·çä¸æ¨çQQï¼æåç»æ¨ã
SQLPLUS常ç¨çå½ä»¤:
edit;(æå¼ç¼åä¸çå½ä»¤è®°äºæ¬)
/ï¼æ§è¡ç¼åä¸çå½ä»¤ï¼
connè¿æ¥
sys/system/sysdba
scott/hr
å建ç¨æ·ï¼
å¿
须以管çåæè¶
级ç¨æ·ç身份ç»å½ï¼æå¯ä»¥å建
以sysç¨æ·ç»å½
sys/as sysdba
以systemç»å½
system@str
password
å建ç¨æ·ï¼
create user myuser identified by myuser;
æäºè¿æ¥çæé
grant connect to myuser;
grant resource to myuser;
å é¤ç¨æ·
drop user myuser;
ç©çç»æ
æ°æ®åºï¼æ¥å¿æ件ï¼æ°æ®æ件ï¼æ§å¶æ件
表空é´-----æ°æ®æ件
myuser:table
create user user01
identified by user01
default tablespace users
temporary tablespace temp;
--å建表空é´
create tablespace myts datafile 'd:/stu/a.data' size 50M;
--æé
--ç³»ç»æé create any table
--对象æé select on scott.emp
--è§è² ï¼ä¸ç»æéçéå ï¼
--connect(è¿æ¥),resource
create role myrole;
grant connect,resource to myrole;
grant myrole to user01;
--ä¿®æ¹å£ä»¤
alter user user01 identified by aaa111;
--ä¿®æ¹ç¨æ·çéå®ç¶æ
alter user scott account unlock;
--ä¿®æ¹è¡¨ç©ºé´
alter user user01 default/temporary tablespace myts;
--解é¤æé
revoke myrole from user01;
--å é¤ç¨æ·
drop user user01;
温馨提示:答案为网友推荐,仅供参考