> I am running Oracle 18.104.22.168 on hpux 10.10, I have created a user without setting the quota
> limits, and I can still create objects, this is not suppose to happen -- therefore I investigated the
> problem and found out the Oracle defaults to 'unlimited tablespace ' on everything when I create a user,
> so I revoke the privilege from the user and set a quota of 0m for the user default tablespace, the problem
> here is I can still create objects, so what is the deal ?
I do not think your problem is on the Oracle side. When one creates an
Oracle user and grant role 'resource'
to a user, this user is granted unlimited tablespace impliedly, (this is
the backward compatibility of role
So it is better that a DBA creates a role which includes all system
privileges the oracle default roles
'CONNECT','RESOURCE' have. This role can be granted to a newly created
user instead of 'CONNECT','RESOURCE'.
After that, you can set quotas of tablespaces in which the user can
create objects in.
Assistant MIS Manager Tel : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd. Fax : (00852)2559 3049