Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle 9i connection string with SYS account

Re: oracle 9i connection string with SYS account

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 5 Jun 2002 11:32:50 +0100
Message-ID: <3cfde8d3$0$238$ed9e5944@reading.news.pipex.net>


"Bertus Dam" <b.dam_at_gmx.net> wrote in message news:3cfdbf32$1_at_news.mhogaming.com...
> Well, Knut was right about 1 thing, this isn't SQL Server. I'm trying to
get
> my application to work with Oracle. It already supports SQL Server. I have
a
> script to fill my database with some stuff. But first I want to create a
> database of course.

No you don't, and there is no of course about it. What you almost certainly want to do is to create a new SCHEMA. You do this by issuing the command

CREATE USER 'BLAH' IDENTIFIED BY 'SOME PASSWORD' DEFAULT TABLESPACE <ANYTHING OTHER THAN SYSTEM OR TEMP> TEMPORARY TABLESPACE <A VALID TEMPORARY TABLESPACE NAME>;

Whilst connected as an account with DBA privs. You then need to grant quota's and other privileges (CREATE SESSION springs to mind) to your new schema owner.

You are probably now thinking that this all looks a lot different to the SQL Server world and you'd be correct up to a point (some of the difference is just semantic).

I'd expect when you have got over this hurdle that your scripts will fail as well.

> Now in SQL Server it works like this: You log on to the
> master database with Integrated Security (O/S security) From there I can
> create a database and create users etc. etc. Only thing I want to know is
> how to do this in Oracle.

In Oracle it doesn't work like this. End of story.
>
> Granting DBA to a user compromises your system, I agree. What Oracle does,
> making things much more complicated than necessary compromises your system
> even more!

Not at all. Not understanding how Oracle works will compromise your system. The same is true for any complex software.

I suggest if you are serious about supporting Oracle you go away and read the Oracle Concepts Guide. If you want it to just act like a different vendors product then limit yourself to that vendors marketplace.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
Received on Wed Jun 05 2002 - 05:32:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US