Date: Tue, 16 Feb 2010 02:30:26 -0800 (PST)
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!
You could try this:
SQL> create user dbauser identified by xxxxxx;
SQL> grant dba to dbauser;
SQL> conn dbauser/xxxxxx
SQL> SQL> create tablespace test1 datafile 'test1.dbf' size 10M;
SQL> create user test1 identified by test1;
SQL> drop tablespace test1 including contents and datafiles;
SQL> drop user test1;
SQL> sho user
USER is "DBAUSER" Received on Tue Feb 16 2010 - 04:30:26 CST