Re: How can I create an oracle schema?

From: R.S. <info_at_bytelife.com>
Date: Sat, 30 Oct 2004 10:27:35 +0200
Message-ID: <41835082$0$34301$cd19a363@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. Received on Sat Oct 30 2004 - 03:27:35 CDT