Re: admin problem, please help!!!

EXACTLY!!!!! I was running the scripts and targeting the local Database Server instance I had in my computer instead of the intended target :-)

YOU are right!!!!!!!

It is a strange behaviour that I login
as system/manager_at_oradb
and during session I change to
fog1/fog1 and it changes from
Database, that is really weird.

1000 Thanks,
Best Regards,
Giovanni

"s.kapitza" <skapitza_at_volcanomail.com> wrote in message news:26703915.0210082335.7c0366ee_at_posting.google.com...
> 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 - 03:56:26 CDT