From: "Daniel A. Morgan" <dmorgan@exesolutions.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: HELP !!!
Date: Sat, 03 Mar 2001 09:30:01 -0800
Organization: EXE
Message-ID: <3AA12A19.A6D724F2@exesolutions.com>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
References: <97pmc1$24j$1@newton3.pacific.net.sg>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Cache-Post-Path: yabetcha.drizzle.com!unknown@win30.drizzle.com
X-Cache: nntpcache 2.4.0b2 (see http://www.nntpcache.org/)
X-Complaints-To: newsabuse@supernews.com
Lines: 36


> How can I connect Oracle Forms & Reports to 8i personal Oracle server? what
> shall I fill in the following fields?
>
> User Name:
> Password:
> Database:

Log on just as you would using SQL*Plus.

If you haven't created a user account in Oracle then by all means do so. Log on
as SYS or SYSTEM and do the following:

CREATE USER yourchoiceofusername
IDENTIFIED BY yourchoiceof password
DEFAULT TABLESPACE youwillneedtohavethenameofatablespaceseebelow
TEMPORARY TABLESPACE temp
QUOTA UNLIMITED ON sameasdefaulttablespace;

THEN

GRANT CONNECT TO yourchoiceofusername;

GRANT RESOURCE TO yourchoiceofusername;

and if it is your own personal copy:

GRANT DBA TO yourchoiceofusername;

To find out the tablespace names run the following:

SQL> SELECT tablespace_name
          FROM dba_tablespaces
          WHERE tablespace_name NOT IN ('SYSTEM', 'RBS', 'TEMP');

Daniel A. Morgan