Patterns » Blog Archive » Oracle: Create new schema/user

Sep 04

Oracle: Create new schema/user

databases Add comments

connect SYS as SYSDBA
create user newuser identified by password;
grant connect,resource to newuser;

Leave a Reply

Recent Posts

VDSL: Bye, bye
07-10-2008
VDSL: My first invoice
07-02-2008
VDSL: For the fun of it…
06-26-2008
Germany vs. Turkey (3:2) …again…
06-25-2008
Germany vs. Portugal (3:2)
06-19-2008

Recent Comments

Dan: This worked perfect for me, thanks a bunch....
Parth Patil: Thanks! That worked for me....
Dustin: Actually the "reset master" command is supposed to work in o...
Mike Batchelder: Does the purge only work if mysql is restarted? That seems t...
Andrei: Thanks, just followed your advice :)...

WP Theme & Icons by N.Design Studio

Entries RSS Comments RSS Log in