日期:2014-05-16  浏览次数:20319 次

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;?

?