oracle实战技巧（六）oracle创建表空间，用户并赋权

  

   

    

     

    
    

     

      //创建表空间 用户 赋权
     
    
   

    

     

    
    

     

      create tablespace shop datafile '/mnt/oradata/ORCL/shop.DBF' size 100m autoextend on next 20m maxsize unlimited;
     
    
   

    

     

    
    

     

      create user shop identified by 123 default tablespace shop;
     
    
   

    

     

    
    

     

      grant connect,resource,dba to DATACENTER;
     
    
   

    

     

    
    

     
 
     
    
   

    

     

    
    

     

      //查看用户是否赋权
     
    
   

    

     

    
    

     

      select * from dba_tablespaces;
     
    
   

    

     

    
    

     

      select * from dba_data_files;
     
    
   

    

     

    
    

     

      select * from dba_users;
     
    
   

    

     

    
    

     
 
     
    
  
 

文章来源: baocl.blog.csdn.net，作者：小黄鸡1992，版权归原作者所有，如需转载，请联系作者。

原文链接：baocl.blog.csdn.net/article/details/115239862