Re: Did column-level grants go away?
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- To: tomday2@xxxxxxxxx
- Date: Sat, 25 Jun 2005 02:39:56 +0000
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.
> --
> //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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
