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
If the user can connect to Oracle then the username has the create
session privilege either directly or as is more likely in this case,
indirectly.
If you can connect as the user you can query session_privs and session_roles. You can then track down the system privileges granted to each role granted the user.
The following article may be of interest: How do I find out which users have the rights, or privileges, to access a given object ? http://www.jlcomp.demon.co.uk/faq/privileges.html
HTH -- Mark D Powell -- Received on Sun Jun 19 2005 - 10:49:51 CDT