Re: ORA-28009

From: <ricforduk_at_yahoo.co.uk>
Date: Tue, 16 Feb 2010 02:30:26 -0800 (PST)
Message-ID: <de37cf9c-6b5e-4fe9-9c04-eec56bc300d6_at_k41g2000yqm.googlegroups.com>

On 15 Feb, 23:19, syd_p <sydneypue..._at_yahoo.com> wrote:
> On 15 Feb, 23:07, Mladen Gogala <n..._at_email.here.invalid> wrote:
>
> > On Mon, 15 Feb 2010 11:33:40 -0800, joel garry wrote:
> > > Have you set things up so someone can connect remotely as sys there?
> > > Connecting locally merely means the local user has group rights.
>
> > The OP has asked the same question on the DBI group and Jared Still, of
> > the "Perl for an Oracle DBA" fame, has given him the same answer I did..
>
> > --http://mgogala.byethost5.com
>
> Hi Guys,
> I am the OP and actually I have only asked the question on this group.
> I kind of thought the answer lies in the Oracle world, hence my
> posting in this group.
> I guess I did not phrase the question very well.
> The problem is that I have a selection of scripts that dont like  "sys
> as sysdba" as a username.
> Dont know why  and I dont want to mess with the scripts.
> What I need is a username of one word (not three that makes the
> scripts barf)
> that has the powers to create tablespaces and users in a database that
> I created with dbca.
>
> Maybe that is possible? If so please help me.
> Thanks for your input so far!
>
> Syd

You could try this:

SQL> create user dbauser identified by xxxxxx;

User created.

SQL> grant dba to dbauser;

Grant succeeded.

SQL> conn dbauser/xxxxxx
Connected.
SQL> SQL> create tablespace test1 datafile 'test1.dbf' size 10M;

Tablespace created.

SQL> create user test1 identified by test1;

User created.

SQL> drop tablespace test1 including contents and datafiles;

Tablespace dropped.

SQL> drop user test1;

User dropped.

SQL> sho user
USER is "DBAUSER" Received on Tue Feb 16 2010 - 04:30:26 CST