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

Home -> Community -> Usenet -> c.d.o.server -> Re: The user can still connect even after CREATE SESSION privilege is revoked

Re: The user can still connect even after CREATE SESSION privilege is revoked

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 18 Jun 2005 12:40:20 -0700
Message-ID: <1119123620.182085.85320@o13g2000cwo.googlegroups.com>


lanegroups_at_go.com wrote:
> Hi,
> I have revoked the CREATE SESSION privilege and the user can still
> connect.
>
> What needs to be done to prevent a user to connect to a database
> besides REVOKE CREATE SESSION FROM user?
>
> How to check the user's setup to make user it doesn't hold any
> privilege to connect to the database?
>
> Thanks,
> Lan

You either have some serious bug that you need to open with oracle (doubtful) asap or somehow the user still has CREATE SESSION ... possibly thru a role granted to the user? Received on Sat Jun 18 2005 - 14:40:20 CDT

Original text of this message

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