Re: new user cant see tables (ORA-04043)

Or you could do like the rest of use, and provide the necesarry synonyms...

dirkske.

"ez" <fake_at_fake.com> wrote in message news:ui586.175627$eT4.13576368_at_nnrp3.clara.net...
> You need to specify the schema owner when connected as the new user and
> doing the select , 'select * from scott.emp'
>
> "Knight" <knight_at_prairie.lakes.com> wrote in message
> news:93q4ka$poj$1_at_nnrp1.deja.com...
> > I just created a user account and assigned it priviledges to select,
> > update, and delete. When I go into SQL Plus I cant see any of the
> > tables. I listed out all the tables and none of them were there. So
> > what I did was changed the default tablespace to the same as the user
> > that created the tables. I still can't see them. Any ideas?
> >
> > --
> > Phil Jenkins
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>
Received on Sun Jan 14 2001 - 14:11:41 CET