Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: The user can still connect even after CREATE SESSION privilege is revoked

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

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 19 Jun 2005 08:49:51 -0700
Message-ID: <1119196191.925064.165160@z14g2000cwz.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US