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 want to prevent UserA to connect to databaseX, so I used userAdmin to
connect to databaseX, and userAdmin issued
set role none;
Role set.
commit;
If userA has to issue these 3 commands to prevent itself from connection, it's odd.
So after userAdmin issued the 3 command above, UserA can still connect to database.
What else is missing?
Or this indeed a bug in Oracle 10g?
Received on Sat Jun 18 2005 - 17:42:30 CDT
![]() |
![]() |