//创建表空间 create tablespace test datafile 'c:\test.ora' size 5M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED default storage (initial 128K next 1M pctincrease 0);//创建该表空间下的用户 create user test identified by test default tablespace test;//赋予权限 grant connect,resource to test;//连接该用户 conn test/test;
revoke resource from username; REVOKE UNLIMITED TABLESPACE FROM username; ALTER USER username QUOTA 100 M ON tablespacename; 只给用户connect 权限
对, connect,resource 这两个角色足够了。
只给connect角色并给用户在default tablespace一定的quota就可以了 grant connect to myuser; alter user myuser quota 100 M on mytablespace; or alter user myuser quota unlimited on mytablespace;
create tablespace test datafile
'c:\test.ora' size 5M
AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
default storage (initial 128K next 1M pctincrease 0);//创建该表空间下的用户
create user test identified by test default tablespace test;//赋予权限
grant connect,resource to test;//连接该用户
conn test/test;
REVOKE UNLIMITED TABLESPACE FROM username;
ALTER USER username QUOTA 100 M ON tablespacename;
只给用户connect 权限
grant connect to myuser;
alter user myuser quota 100 M on mytablespace;
or
alter user myuser quota unlimited on mytablespace;