Re: new user cant see tables (ORA-04043)
From: ez <fake_at_fake.com>
Date: Sat, 13 Jan 2001 23:14:28 -0000
Message-ID: <ui586.175627$eT4.13576368_at_nnrp3.clara.net>
Date: Sat, 13 Jan 2001 23:14:28 -0000
Message-ID: <ui586.175627$eT4.13576368_at_nnrp3.clara.net>
[Quoted] 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 - 00:14:28 CET