Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: why the FGAC policy does not work when meeting with user 'sys'

Re: why the FGAC policy does not work when meeting with user 'sys'

From: LiShan Cheng <exriscer_at_gmail.com>
Date: Tue, 11 Apr 2006 00:47:35 +0200
Message-ID: <6e9345580604101547h4b3e85a6t40b2800127945774@mail.gmail.com>


Hi

sys is superuser, you cannot apply restriction to superusers

On 4/10/06, xiaoyan <xiaoyezi.xyz_at_163.com> wrote:
>
> Hi,
> As we all know, when a user connects to database with 'AS SYSDBA'
> option, no matter what his account name is,the value
> of 'sys_context('userenv','session_user') is alway 'sys',then if i execute
> my access control based 'sys',why the policy does not work?
>
> Then,how can I exectute access control to users those connect to
> database with option'AS SYSDBA'?
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 10 2006 - 17:47:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US