Re: HELP !!!

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sat, 03 Mar 2001 09:30:01 -0800
Message-ID: <3AA12A19.A6D724F2@exesolutions.com>

> 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 Received on Sat Mar 03 2001 - 11:30:01 CST