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

Hey,

Thanks! But do you also know what I have to use for the USERSTING?

Breno de Avellar Gomes heeft geschreven in bericht <3727590A.117FBE60_at_ieee.org>...
>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 - 17:37:48 CDT