Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: session_privs
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...
![]() |
![]() |