Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: why the FGAC policy does not work when meeting with user 'sys'
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-lReceived on Mon Apr 10 2006 - 17:47:35 CDT