how to create new database

hi all members

can any one tell me how i would create new database with granting all priviledges.

re: how to create new database

Fist create a new user...Go to Administration....Manage Users i think and there is and option to create new user...

Click this name the user..put a passwor and select all the check boxes below...and click save.

Your new user is created and then...logout and then log back in as this user and create your tables etc.

Hope this helps..

re: how to create new database

hi can u plz help me to register a new user..cuz i never used oracle before
these are the instructions "readmefirst" file
On the desktop is a file called new_user.sql
Edit this file replacing user_name (4 times) with your student ID and password (1 time) with a password of your choice.
save the script as c:\new_user.sql
log on to the database using sqlplusw
use the username system, password manage
the database Host is oracle
at the SQL prompt type
@c:\new_user.sql
you should see the following appear
User created.
Grant Succeeded.
Grant Succeeded.
User Altered.
you have now created your Oracle user.
and this is the file which i need to replace with it

create user user_name identified by password
default tablespace "USERS" temporary tablespace "TEMP"
profile default quota 20 M on "USERS" quota 20 M on "TEMP" ACCOUNT unlock;

grant "CONNECT" to user_name;
grant "RESOURCE" to user_name;
alter user user_name default role all; saved as new_user.sql
thank you
l3esartii_uk@hotmail.com