orcal操作锦级

上一篇 / 下一篇  2018-01-16 11:23:28 / 个人分类:oracle


登录:
sqlplus / as sysdba

--表空间 
CREATE TABLESPACE sdt  
DATAFILE 'E:\oracle\tablespace1' size 2000M  
         EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;   
         
--索引表空间  
CREATE TABLESPACE sdt_Index  
DATAFILE 'E:\oracle\tablespace2' size 1000M           
         EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;  
         
--建用户  
create user test1 identified by test1   
default tablespace sdt;  
   
--赋权  
grant connect,resource to test1;  
grant create any sequence to test1;  
grant create any table to test1;  
grant delete any table to test1;  
grant insert any table to test1;  
grant select any table to test1;  
grant unlimited tablespace to test1;  
grant execute any procedure to test1;  
grant update any table to test1;  
grant create any view to test1;  

TAG:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

Open Toolbar