Re: one more in the mix (newcomer)

The best to do is find someone that knows Oracle to help you. For example contact the local Oracle users group. This question is easy ... but there will be thousands more.

Log on as SYS

SELECT tablespace_name
FROM dba_tablespaces

(don't use SYS, RBS, or TEMP for the next step)

CREATE USER <username>
IDENTIFEID BY <password>
DEFAULT TABLESPACE <result from previous query except as noted> TEMPORARY TABLESPACE temp
QUOTA UNLIMITED ON <default tablespace name>;

GRANT CONNECT TO <username>;
GRANT RESOURCE TO <username>;
GRANT DBA TO <username>;

That should get you going. It is a horrible configuration for a work environment but suitable for just learning about Oracle.

Daniel Morgan

digital smacktastic wrote:

> hello serious oracle ones,
> i just installed oracle on my linux box for the sole purpose of seeing
> what it looks and feels like. i have not played to much with many
> databases (some unidata, some mysql), so i don't know much about
> database administration. i was wondering if someone can point me toward
> some real beginner style documentation (i'm still trying to figure out
> how to add a users to this thing)? any direction would be greatly
> aprreciated.
>
> digitalsmack
Received on Wed Feb 06 2002 - 12:13:57 CST