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: How to implement this security model?

Re: How to implement this security model?

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Thu, 27 May 2004 00:23:03 +0200
Message-ID: <646ab0dp0ebq0knucsm43ue50q85s03ioh@4ax.com>


On 26 May 2004 12:18:17 -0700, aaron.kurz_at_acs-inc.com (Aaron) wrote:

>Running Oracle 9i (9.2.0.4) on Solaris
>
>We need to be able to allow end-users to add and drop columns from a
>particular table, but need to restrict their drops to only the columns
>which they (end-users) have added. In other words, we have a table
>with columns which must remain, but the end-user should be able to add
>and remove his own columns at will.
>
>I thought DBMS_RLS might be a path to take, but it doesn't seem to
>have an ADD_POLICY for ALTER statement.
>
>Any idea's would be appreciated.
>
>Thanks.

The idea is just completely horrible. Your database will be completely out of control, and likely it already is. The best move you would make is to quit this mess as soon as possible.

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed May 26 2004 - 17:23:03 CDT

Original text of this message

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