Re: create schema question

From: Brian Gallagher <briang_at_iona.com>
Date: Fri, 4 Jun 1999 16:30:04 +0100
Message-ID: <7j8rlo$otg$1@bvweb.dublin.iona.ie>

create user horizon identified by password;

will create a user(schema) horizon. Normally you would wish to specify default/temporary tablespaces and quotas for default. you would need to give permissions e.g.

grant connect to horizon;

hope this helps

regards
brian

Robert Britton wrote in message <3757dfe1_at_news.pcom.net>...
>I need to create a schema called 'horizon'.
>
>I tried
>
>create schema authorization horizon;
>
>and it doesn't work.
>
>How can I do this?
>
>Oracle 8.0.5/nt.
>
>bob @ themicrocenter.com
>
>
Received on Fri Jun 04 1999 - 10:30:04 CDT