Re: After creating a dababase what do i do next?

Hi!

My opinion is that it could be easier to work on a simple example : - define a little project : a simple tool to ... - define the information that the system should keep track, and the operations
  the tools will perform (transactions: insert, update, delete, select) - then define the involved tables for these informations (that is called a schema)
- after that, you create

• the database
• a user which owns the schema (typically the dba), with full rights on the database (or so)
• the schema's objects (tables, views, indexes) - the next step is to work on the end-user tool. you:
• create another user with less rights (only read/write on tables) : the enduser
• design your application's screens (even if it is in PL/SQL), according to the above transactions with this second user
• use the Client-Server tool : that's it If you modify the schema (add objects to the db), then you do it with dba user. if you modify the transactions, then you modify the end user tool with enduser - the next step is to use the tool...

Hope this helps
MK :-)

PS: you could take a look at Merise, and Oracle's documentation, which is very usefull.

Gareth Leonard wrote:

> Hi there,
>
> I have just created an Oracle database with NT Instance Manager GUI on
> the Oracle 7.3 server. What I would like to do now is create a simple
> table for it. I am using server manager and logging in with connect
> internal/password. Is this the correct way to do this in order to run my
> SQL scirpt. Or should I log in with my database password into server
> manager?
>
> Ie
>
> Sid = test
>
> Password = password
>
> What are the correct steps?
Received on Fri Feb 27 1998 - 00:00:00 CST