On 26 May 2004, aaron.kurz_at_acs-inc.com 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.
I would use DBMS_RLS to store the names of the columns that a
particular user created. Then, that would be the driver for what
columns they can remove.
--
Galen Boyer
Received on Wed May 26 2004 - 14:27:36 CDT
