Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: restricting schema owner privileges
Susan
Nope. Bad design. There is no way I know of to remove privileges from the owner of the tables.
One way to fix it though would be to export all the objects, import them to another user, then grant the original user the necessary DML access only to the new user's tables.
HTH. Pete
Susan Schuster wrote:
> I have inherited db support for an application package which has a
> single sign-on for all users. This application is modifiable by the
> end-user at all times and the modifications can include ddl. So in
> essence, an end user can alter,drop and add objects in production at
> will or unintentionally.
>
> Is there anyway that the privileges of the schema owner can be
> restricted to not allow these changes? It is version 8.0.5 on NT.
>
> thanks!
>
> susan
--
Regards
Pete
Received on Fri Jul 09 1999 - 11:22:47 CDT