SQL>create temporary tablespace user_temp
datafile '/data1/oradata/user_temp.dbf'
size 5000M autoextend on
//创建数据表空间
SQL>create tablespace user_temp
datafile '/data1/oradata/user_temp.dbf'
size 500M autoextend on
(这些只是例子,具体数据文件的路径,大小,都要你自己改,这里的是不自动扩展,你如果想自动扩展,autoextend on next 50m maxsize 2048m,上网查一下就可以了)
//创建用户并指定表空间
SQL>create user username identified by password
default tablespace user_data
temporary tablespace user_temp
//给用户授予权限
SQL>grant connect,resource to username
mysql>CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword'mysql>SELECT host, user, password FROM mysql.user WHERE user='myuser'mysql>GRANT ON . TO 'myuser'@'localhost'欢迎分享,转载请注明来源:内存溢出
评论列表(0条)