读书人

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

发布时间: 2012-07-29 15:26:14 作者: rapoo

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

?

读书人网 >其他数据库

热点推荐