Re: Can't DESC table in SQL PLUS (Have proper synonyms and privs on owners table)

A copy of this was sent to "Chris Gladwin" <mangi1_at_hotmail.com> (if that email address didn't require changing) On Wed, 11 Aug 1999 12:38:19 GMT, you wrote:

>Hi all,
>
>I have a user (x) with all privileges on tables owned by (y). Synonyms are
>created properly in (y's) schema. User (x) can SELECT, UPDATE, INSERT and
>DELETE but cannot DESC table in SQL PLUS withour prefixing tablename with
>y's schema. Why?
>
>User (x) can DESC table in SVRMGR!!
>
>Thanks,
>
>Chris G
>

you must have sqlplus 8.0.3. that is an issue with sqlplus 8.0.3 fixed in 8.0.4 and up.

-- 
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
 
Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation