Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create user/schema is script, then tables for that user/schema

davidthi808-JavaNetMar 13 2007 — edited Mar 14 2007
Hi;

First off, if I phrase this a little wrong - I'm from the Sql Server world and still trying to totally understand Oracle.

I have a schema (.sql file) that creates my database fine. But what I would liek to add to the .sql schema is for it to create a user and then place all the tables, indexes, sequences, and triggers in as belonging to that created user.

This way we can tell people to log in as sysop and run the script to create the schema rather than create the user, log in as the user, then run the script.

What do I need to add?

thanks - dave
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2007
Added on Mar 13 2007
5 comments
403 views