Re: Did column-level grants go away?

On 06/24/2005 09:23:23 PM, Thomas Day wrote:
> I was looking at a 9.2 database the other day and noticed
> DBA_COL_PRIVS. It had no rows in it. I'll have to look into Jacque's
> offering. Though obviously I don't have any need for it. Just
> another tool for the toolbox.
> --
> http://www.freelists.org/webpage/oracle-l
>
>

Syntax is a little bit strange, but you can still do it:

$ sqlplus scott/tiger

SQL*Plus: Release 10.1.0.4.0 - Production on Fri Jun 24 22:37:53 2005

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> grant update(sal,comm) on emp to ops$mgogala;

Grant succeeded.

SQL>

-- 
Mladen Gogala
Oracle DBA


--
http://www.freelists.org/webpage/oracle-l