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: session_privs

Re: session_privs

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sun, 20 Feb 2005 15:40:32 -0800
Message-ID: <1108942654.794639@yasure>


nitin_kaul_at_rediffmail.com wrote:

> HI
>
> I HAVE NOT GRANTED SELECT ANY DICTIONARY TO(JOHN) ONE OF THE USERS IN
> THE DB..WHEN I LOG IN AS JOHN USER AND QUERY SESSION_PRIVS IT SHOWS
> THAT IT HAS BEEN GRANTED TO THAT USER.SO IT IS ABLE TO SELECT ANY
> TABLE.
> WHEN I QUERT THE VIEW DBA_SYS_PRIVS LOGGED IN AS SYSTEM USER
> IT DOESNOT SHOW THAT PRIV HAS BEEN GRANTED TO JOHN...

  1. Stop screaming!
  2. Do you have a question?
  3. What version? -- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)
Received on Sun Feb 20 2005 - 17:40:32 CST

Original text of this message

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