Re: sql developer not showing table names
From: <gareth_at_jamms.org>
Date: Fri, 15 May 2009 02:54:59 -0700 (PDT)
Message-ID: <e88934bb-41b5-4daf-b8dd-0926aa60cdc3_at_n4g2000vba.googlegroups.com>
On 15 May, 08:50, DeB <debashish.majum..._at_gmail.com> wrote:
> Hi All,
> I have created a new user and granted it resource and connect
> privileges. I have created a few tables this new user's schema but I
> am not able to see those in SQL Developer. However when I issue -
> "select * from tab", I am able to see the table list. Do I need any
> other privileges to be granted to the new user? Please suggest.
>
> Thanks in advance
> DeB
Date: Fri, 15 May 2009 02:54:59 -0700 (PDT)
Message-ID: <e88934bb-41b5-4daf-b8dd-0926aa60cdc3_at_n4g2000vba.googlegroups.com>
On 15 May, 08:50, DeB <debashish.majum..._at_gmail.com> wrote:
> Hi All,
> I have created a new user and granted it resource and connect
> privileges. I have created a few tables this new user's schema but I
> am not able to see those in SQL Developer. However when I issue -
> "select * from tab", I am able to see the table list. Do I need any
> other privileges to be granted to the new user? Please suggest.
>
> Thanks in advance
> DeB
Well get rid of CONNECT and RESOURCE. If you're using a reasonably recent version of Oracle, these roles are deprecated and grant way too many more privileges than required. Your user needs CREATE SESSION, minimally, then any additional privileges required to create objects.
As I can't what you're doing in SQL Developer, I can't really say what the problem is. Are you looking under the right schema?
HTH -g Received on Fri May 15 2009 - 04:54:59 CDT