"R.S." <info_at_bytelife.com> wrote in message news:<41835082$0$34301$cd19a363_at_news.wanadoo.nl>...
> "Guillermo Uriarte" <guiuriarte_at_yahoo.es> schreef
> > How can I create an oracle schema?
>
> create a user, and ...
> You might give the new user someting to create in his/her schema:
> Grant create session to &&USERNAME ;
>
> Grant create table to &&USERNAME ;
>
> Grant create view to &&USERNAME ;
>
> Grant create trigger to &&USERNAME ;
>
> Grant create procedure to &&USERNAME ;
>
> Grant create sequence to &&USERNAME ;
>
> grant create synonym to &&USERNAME ;
>
> cheers,
>
> Roelof
> ---------------------------------
> I really hate this damned machine
> I wish that they would sell it.
> It never does quite what I want
> But only what I tell it.
Thanks a lot for answering.
Received on Sat Oct 30 2004 - 11:21:41 CDT
