470,624 Members | 2,511 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,624 developers. It's quick & easy.

Which clause in a create user statement restricts the number of tables a user can add


Which clause in a create user statement restricts the number of tables a
user can add to a tablespace?
--
Posted via http://dbforums.com
Jul 19 '05 #1
1 2068
valexena <me*********@dbforums.com> wrote in message news:<35****************@dbforums.com>...
Which clause in a create user statement restricts the number of tables a
user can add to a tablespace?


Well, I don't think there is an explicit way of saying that a user can
create n tables in a tablespace. However, you can set tablespace
quotas for a user. E.g:

ALTER USER fred QUOTA 20M ON USERS;

means user fred cannot consume more that 20M of space within the USERS
tablespace.
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Jason | last post: by
5 posts views Thread by rAinDeEr | last post: by
6 posts views Thread by Plissskin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.