Re: Create new users

Hello:

I am just new to Oracle as well and don't know how to even execute the example you gave. I assume it can be executed using SQL Plus? I have Oracle8 for Windows95/NT (trial) version.

Whenever I try to run SQL Plus I get asked for a user name/password etc. I have no idea what to put in and when I put in ORACLE/ORACLE/ORCL (specified
in the documentation)
then my machine connects to the internet through DUN and then I get an error message saying unable to resolve name with TNS.

My machine is not on a LAN but has a NIC and of course a dial up adaptor.

Is it possible to set things up for just a local machine? Any help would
be appreciated. The documentation is very hard to read when you have so little experience with Oracle...

Thanks,

Jim Norton

Breno de Avellar Gomes wrote:
>
> Hi Johan
>
> The basic syntax to create users in Oracle8 is:
>
> CREATE USER "THEUSER" IDENTIFIED BY "thepassword" DEFAULT TABLESPACE
> "USER_DATA" TEMPORARY TABLESPACE "TEMPORARY_DATA" PROFILE DEFAULT
> ACCOUNT UNLOCK;
> GRANT "CONNECT" TO "THEUSER";
> GRANT "RESOURCE" TO "THEUSER";
> GRANT UNLIMITED TABLESPACE TO "THEUSER";
> ALTER USER "THEUSER" DEFAULT ROLE ALL;
>
> replace "THEUSER" and the password as appropriate - double quotes are
> part of syntax.
>
> In order to give access to db1 use
> GRANT "CONNECT" ON username.db1 TO "THEUSER" where username is the user
> who created the table
>
> Send me an email for more details
>
> Johan den Boer wrote:
>
> > Hello,
> >
> > I am a newbie in oracle. How can you add a user to the database and
> > how do you give access to a database. Suppose you have two
> > databases db1 and db2. How do you give access to only database db1
> > and not to db2. Is there a tool in oracle ?
> >
> > Please send me email to jj.den.boer_at_hccnet.nl
> >
> > Thanks a lot
Received on Sun Apr 18 1999 - 10:13:29 CDT