create user in solaris

From: Gabor Friedrich <gabor_at_internetaddress.com>
Date: Fri, 22 Oct 1999 21:25:41 +0200
Message-ID: <pbkQOPhhN1kexIYgjFOOz0sEfOaa@4ax.com>

i have an installed oracle server on a solaris-system. up to this time i has worked with an oracle-server on nt-systems. now i must create an database on the solaris. the connect between with the enterprise manager from the nt-system to the solaris machine i have not become to work.
is there any idee to get this connection. i use an tcp network, and i can ping the computers.

second how can i create an user on the solaris-oracle (i hav'nt any graphicly programs found, also i must use the command-line tools.)

i get an error thats says that an tablespace user_data is not exist..

the command:"CREATE USER "GABOR" IDENTIFIED BY "gabor" DEFAULT TABLESPACE "USER_DATA" TEMPORARY TABLESPACE "TEMPORARY_DATA" PROFILE DEFAULT ACCOUNT UNLOCK;

GRANT "CONNECT" TO "GABOR";
GRANT "DBA" TO "GABOR";
GRANT "RESOURCE" TO "GABOR";

GRANT UNLIMITED TABLESPACE TO "GABOR";
ALTER USER "GABOR" DEFAULT ROLE ALL;" where is the error or how can i list the available tablespaces ?? please help me..

mfg Gabor Received on Fri Oct 22 1999 - 14:25:41 CDT