admin problem, please help!!!

From: Giovanni Azua <bravegag_at_hotmail.com>
Date: Tue, 8 Oct 2002 16:18:03 +0200
Message-ID: <anupfd$hjkpf$1@ID-114658.news.dfncis.de>

Hi all,

I logged in as system and created a new user associated with an existing tablespace like this:

CREATE USER FOG1 IDENTIFIED BY FOG1

       DEFAULT TABLESPACE FOG1_DATA
       QUOTA 100M ON FOG1_DATA

GRANT CREATE SESSION, IMP_FULL_DATABASE TO FOG1
/

GRANT JAVASYSPRIV, JAVAUSERPRIV TO FOG1
/

GRANT ALL PRIVILEGES TO FOG1
/

GRANT CONNECT, RESOURCE TO FOG1
/

I ran lot of importing procedures to move an existing database schema into a new redesigned version of the schema (they are in two different tablespaces). The problem is that after I properly import everything, the user FOG1 can not see any of the objects created, how is it that possible?

I am also happening this:

I login as system:

>sqlplus system/manager_at_oradb
-- and connect now as FOG1/FOG1
sqlplus>connect FOG1/FOG1
-- Voila can see everything!!! all the tables, procedures etc etc etc -- e.g. describe FOG1.TABLE1 etc etc

The funny thing is that I can see the user FOG1 but not the tablespace FOG1_DATA
from the Database Management Console.

what can the problem possibly be? I am a poor developer without too much Oracle admin exposure and the admin is currently in holidays ;-(

TIA,
Best Regards,
Giovanni Received on Tue Oct 08 2002 - 09:18:03 CDT