Re: Managing Column-Selective Object Privileges

On Wed, 22 Jun 2005 21:45:13 +0200, "Thomas Blankschein" <thomas_at_blankschein.de> wrote:

>Hi,
>
>the documentation for 9.2 says:
>
>"Although users can grant column-selective INSERT, UPDATE, and REFERENCES
>privileges for tables and views, they cannot selectively revoke column
>specific privileges with a similar REVOKE statement. Instead, the grantor
>must first revoke the object privilege for all columns of a table or view,
>and then selectively re-grant the column-specific privileges that should
>remain."
>
>Is there any tool (maybe a package from Oracle itself) which simplifies this
>thing? I think of a possibility to add and revoke single column privileges,
>without knowing all existing privileges on this table.
>
>Thanks,
>Thomas
>

Can definitely be written in pl/sql quite easily, but not for free.

--
Sybrand Bakker, Senior Oracle DBA