Revoke it.
Make sure they aren't getting the right from a superior role, like DBA
or sysdba, or revoke will only work per session... if at all.

Jeffrey C. Ferrel
DMS III
State of Nevada
775.687.9327
[Email address protected]


-----Original Message-----
From: Linus Li
[mailto:oracledba-ezmlmshield-x2025814.[Email address protected]
Sent: Monday, March 05, 2007 9:23 AM
To: LazyDBA Discussion
Subject: how to grant a user no right to create a new table in Oracle

Could anybody please tell how to grant a user no right to create a new
table in Oracle?

Linus


---------------------------------------------------------------------
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



Oracle LazyDBA home page