Re: Dictionary: DBA_TAB_PRIV

You do not have the priv on your user to view that table. You either have to have the DBA role assigned to your user or have the table granted explicitly to you.

That is something you should pick up in the first 5 minutes of your DBA studies! ;-)

M

atlguy01_at_hotmail.com wrote in message news:<3c75e339.12683657_at_news.atl.bellsouth.net>...
> I am studying my SYBEX OCP, ORACLE 8I SQL and PL SQL book.
> I am recently installed Personal Oracle 8I on WIN 98, and am trying
> to run the following SQL....
>
> SQL> SELECT grantee,privilege
> 2 FROM dba_tab_privs
> 3 WHERE owner='myschema' AND table_name='myobject';
> FROM dba_tab_privs
> *
> ERROR at line 2:
> ORA-00942: table or view does not exist
>
> Any ideals what is causing this?
>
> I gotta admit... ORACLE seems to be VERY COMPLEX... and I am wondering
> can i achieve my DBA on my own. Atually.... I am beginning to re-think
> this, and instead.. pursue a MCSD certification in Visual Basic, which
> I DO have a grasp of.
>
> Thanks...
>
> SQL> select * from V$VERSION
> 2 /
>
> BANNER
> ----------------------------------------------------------
> Oracle8i Personal Edition Release 8.1.5.0.0 - Production
> PL/SQL Release 8.1.5.0.0 - Production
> CORE Version 8.1.5.0.0 - Production
> TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
> NLSRTL Version 3.4.0.0.0 - Production
Received on Fri Feb 22 2002 - 11:13:46 CET