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

lanegroups_at_go.com wrote in
news:1119130150.630120.30420_at_g43g2000cwa.googlegroups.com:

> I also did REVOKE CONNECT from user. But the user still can connect.
>
> I verified the user has no rows or no privilege by issuing the
> following 2 queries
> SELECT * FROM sys.dba_role_privs where GRANTEE='XYZ';
> SELECT * FROM sys.dba_role_privs where GRANTEE='XYZ';
> Both of them return 0 row.
>
> Still, the user can connect to the database.
>
> What else is missing?
>
> Thanks.
>
>

set role none;

Role set.

commit; Received on Sat Jun 18 2005 - 17:19:08 CDT