Managing Column-Selective Object Privileges

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 Received on Wed Jun 22 2005 - 14:45:13 CDT