萬盛學電腦網

 萬盛學電腦網 >> 數據庫 >> oracle教程 >> 在Oracle中如何創建表空間、用戶、權限分配

在Oracle中如何創建表空間、用戶、權限分配

  1:創建表空間 wspspace,maxsize unlimited是大小不受限制

  Sql代碼

  create tablespace wspspace

  datafile 'D:/dev/oracle/tablespace/wspspace.dbf' size 300M

  autoextend on

  next 50M

  maxsize unlimited

  2.創建用戶

  create user wsp identified by wsp default tablespace wspspace;

  3.分配權限

  grant connect,resource,create view to wsp;

copyright © 萬盛學電腦網 all rights reserved