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

From: Austin <hacketta_57_at_yahoo.com>
Date: 3 Nov 2003 09:39:37 -0800
Message-ID: <c59a59b7.0311030939.53e0a1af_at_posting.google.com>

valexena <member43815_at_dbforums.com> wrote in message news:<3551995.1067847526_at_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. Received on Mon Nov 03 2003 - 18:39:37 CET

This message: [ Message body ]
Next message: Austin: "Re: In which table is Oracle database audit information stored?"
Previous message: Austin: "Re: 1. Do you know in which tablespace the tables that store information about the Oracle"
In reply to valexena: "Which clause in a create user statement restricts the number of tables a user can add"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message