Re: admin problem, please help!!!

hi Giovanni,

if you issue
> >sqlplus system/manager_at_oradb

you connect to oradb

if you issue

> sqlplus>connect FOG1/FOG1

you connect to the database which is set via ORACLE_SID in your OS enviroment (whatever it is, you dont mention it)

so possible you are using two databases. just a possibility.

hth.

s.kapitza

"Giovanni Azua" <bravegag_at_hotmail.com> wrote in message news:<anupfd$hjkpf$1_at_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 Wed Oct 09 2002 - 02:35:46 CDT