Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to prevent drop on a specific table
the owner can drop the table, so if you want to prevent users from
being able to drop the table or other tables, here is what I'd do:
I keep all my users very restricted in what they can do. Only I as the DBA can do any harm to the DB, users are only allowed to view/select, update or delete (if I deem necessary) data. Users are never allowed to create, add, drop tables, indexes, constraints, etc -- that is all done by me only.
-Greg
PMDORAIS_at_gmail.com wrote:
> HI, i'm not a big wiz with oracle but i would like to prevent dropping
> a specfic table only for all users.
>
> How can i do that?? ps. i use Oracle9i Enterprise Edition Release
> 9.2.0.5.0 .
>
>
> Thanks!!!!
Received on Fri Jun 23 2006 - 11:09:13 CDT