by default that is true but in 8i you can use schema triggers so even
the owner can't drop his own table(assuming they dont have dba privs and
can disable the trigger).
joe
Djordje Jankovic wrote:
>
> Every user can do whatever (s)he wants with her/his own objects.
>
> The only way how you can achive what you want is to create objects in the
> schema X, do not let user Y to create any objects, and grant user Y only the
> privileges you want for objects in schema X.
>
> HTH
>
> Djordje
>
> -----Original Message-----
> To: Multiple recipients of list ORACLE-L
> Sent: 11/16/00 9:30 PM
>
> Can Every User by default can drop and alter his /her own tables.
> Suppose i want to give only select ,insert,update privileges.How can I
> give
> ??
> IS it possible.pl. tell me.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dash, Saroj (CAP,CEF)
> INET: Saroj.Dash_at_gecapital.com
--
Joe Testa http://www.oracle-dba.com
No you can't fix an ORA-600 error, call Oracle Support.
Received on Thu Nov 16 2000 - 22:08:42 CST
