oracle 创建用户，授权，创建表空间

-- Create the user
create user VIDEOYN
  identified by ""
  default tablespace VIDEOYN
  temporary tablespace TEMP
  profile DEFAULT;

 

-- Grant/Revoke role privileges
grant connect to VIDEOYN;

grant CONNECT to videoyn;

 

grant RESOURCE To videonb;

create tablespace videoyn datafile 'D:\Program Files\oracle\product\Video.dbf'   
size 512M autoextend on next 10M maxsize unlimited;