Re: one more in the mix (newcomer)

thanks for the assist. 1 down, hundreds to go and i am off to search the the nearby user group.

keep up the fine work.

damorgan wrote:

> 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
>>