Revoke the role resource from the user and then grant that user the
quota you want on the tablespace you specify.

i.e.

Revoke resource from 'user';
Alter user 'user' quota xM on tablespace yyy;

-----Original Message-----
From: Patrick Reither
[mailto:oracledba-ezmlmshield-x79854002.[Email address protected]
Sent: 28 February 2007 16:46
To: LazyDBA Discussion
Subject: Re: USER MANAGEMENT

Perhaps the user has the RESOURCE role which has the UNLIMITED
TABLESPACE system privilege.
Pat Reither

Naim Akhter wrote:

>Hi Everybody,
>
>
>
>I want User should not be able to create objects in any other
>
>Tablespace other than the assigned tablespace,at least not in System
>Tablespace
>
>
>
>
>
>For that I have executed the command
>
>
>
>SQL>alter user username
>
> Quota 0 on system;
>
>
>
>But still that user is able to create objects in System Tablespace
>
>
>
>That user has no quotas assigned in any other tablespace
>
>
>
>Is there any way by which I can restrict all the users
>
>Not to be able to create any objects in system tablespace
>
>
>
>Regards
>
>Naim Akhter
>
>
>
>---
>This e-mail message may contain confidential, proprietary or legally
privileged information. It should not be used by anyone who is not the
original intended recipient.If you have erroneously received this
message, please delete it immediately and notify the sender. The
recipient acknowledges that 3i Infotech or its subsidiaries and
associated companies, (collectively "3i Infotech"), are unable to
exercise control or ensure or guarantee the integrity of/over the
contents of the information contained in e-mail transmissions and
further acknowledges that any views expressed in this message are those
of the individual sender and no binding nature of the message shall be
implied or assumed unless the sender does so expressly with due
authority of 3i Infotech. Before opening any attachments please check
them for viruses and defects.
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Disclaimer NoticeThis e-mail, any attachments thereto and response string is intended solely for the attention and use of the addressee(s) named herein and may contain legally privileged and/or confidential information. In the event that you are not the intended recipient(s) of this e-mail and any attachments thereto, be notified that any dissemination, distribution or copying of this e-mail and any attachments thereto, is strictly prohibited. If you have received or otherwise encountered this e-mail in error, please immediately notify the sender and permanently delete the e-mail, any attachments and response string as well as any copy printout in connection therewith.

Oracle LazyDBA home page