Re: SYS.DUAL

Jeff B wrote:
> Does anyone know what SELECT privilege granted to PUBLIC gives users
> access to the SYS.DUAL?
>
> This is for Oracle 9.2.0.8 on Windows 2003 Server.
>
> Due to security regs, we have revoked just about everything from
> PUBLIC. I was hoping not to have to search one by one until I found
> the correct privilege.
>
> Thanks in advance!
> Jeff

In 11g $ORACLE_HOME/rdbms/admin/dsec.sql contains the following:

grant select on dual to public with grant option.

No doubt something similar exists in sql.bsq or a similar file in 10g or below.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org