Re: Oracle 8 - SQL+ login/username/string?

User scott
password tiger
is the default user defined by installation.

You can use Security Manager to define more users or create manually using the following syntax in Sql*Plus (logon as system, password mamager)

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

"Jeroen (JFF)" wrote:

> Hey,
>
> I've just installed Oracle 8 on my pc to use it for my study.
> But which password/login/string do I have to use when I startup SQL. Do I
> have to create one myself or should the password/login/string be brought
> with the package?
>
> Who can help me?
>
> Jeroen (who just started to use Oracle.....)

Received on Wed Apr 28 1999 - 13:52:58 CDT