Creating tables - Newbie question

I'm trying to run an SQL script to create tables for a new database. This is only for development, not production.

1. Is it common to create a new tablespace for these tables? I noticed that the demo tables are all in the SYSTEM tablespace. Is this standard? And how do I create a new tablespace with the proper permissions (see next question).
2. I want to connect to the database from a client app. I want to have one user "own" the database (may be system or somesuch), and another user that can only query, update, insert, but not delete (basically restricted for web access). I can't seem to create the tables with the proper ownership, nor proper access. Can someone outline the steps necessary?
   • Ed Wang

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Apr 03 2000 - 00:00:00 CDT