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

[valexena]

Which clause in a create user statement restricts the number of tables a
user can add to a tablespace?
--
Posted via http://dbforums.com

[Austin]

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.