Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: The user can still connect even after CREATE SESSION privilege is revoked
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