Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to implement this security model?
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 DBAReceived on Wed May 26 2004 - 17:23:03 CDT