Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: restricting schema owner privileges

Re: restricting schema owner privileges

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Fri, 09 Jul 1999 09:22:47 -0700
Message-ID: <378621D6.F1F21039@us.oracle.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US