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]

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

valexena <member43815@db forums.comwrote in message news:<3551995.1 067847526@dbfor ums.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.