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
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. Received on Sat Jun 18 2005 - 16:29:10 CDT