Can't login to Designer 2k with any id/password? 
Author Message
 Can't login to Designer 2k with any id/password?

I am fairly new to Oracle 8 as well as Designer 2000.
I installed Oracle 8 Enterprise on my laptop and had the Oracle
Installer also install the pre-seeded database for me (I figured I
needed a database for Designer 2k to use).

When I tried to start Designer 2000 I used the SYSTEM/MANAGER
id/password but D2K states that I cannot use SYSTEM.

So, using Enterprise Manager GUI I created my own userid with the
appropriate roles/priveleges (I thought).  But I still cannot get passed
the Designer 2K login screen.  It tells me that it cannot connect to the
repository and that my userid/password is bad/wrong.  

I have been trying/creating various id's but without success.

Can anyone help me here as to what I need to do and how to create a
correct user id/password for D2K to work?  Do I need to create my own
database rather than trying to use the pre-seeded Oracle 8 database, and
if so, how?
I'd appreciate a quick walkthrough as to the correct way to
create/authorize a new user (which ID to use to create) as well as how
to login to D2K with the new userid (i.e. enter anything other than the
userid/pw on the login popup?).

Thank you.

Walter



Wed, 20 Jun 2001 03:00:00 GMT
 Can't login to Designer 2k with any id/password?

No, you don't have to create a database, you can use the preseeded database.
The preseeded database should already come with a repository owner.  To find
out what the userid that owns the repository, query the dba_objects view
logged in as sys or system using the following command (via sqlplus):

select distinct owner from sys.dba_objects
where owner not in ('SYS','SYSTEM');

The userid that is returned will be the owner of your repository.  You can
then alter that users password to something you know by issuing the
following statement (from sqlplus):

alter user whatever_user_you_found identified by new_password;

Then, try to connect to that user/password through sqlplus.  You should be
able to connect.  You can then login through D2K using this userid/password
combination.

Adding D2K users, (Other than repository owner), is a two step process.  You
have to create the user and assign them a  role through sqlplus.  You then
have to use the repository admin utility to finish the setup.  I am not in
front of the RAU right now, otherwise I would give you the exact steps...

Jeff Hunter



Wed, 20 Jun 2001 03:00:00 GMT
 Can't login to Designer 2k with any id/password?
On the assumption that the blind are better leading the blind than
no-one...
Are you aware that Designer needs to store information for its own
purposes (i.e. not the data in your database) ?  It does this in its
own part of a database (the one you are interested in or indeed any
other - even remote) and this part is called a repository.  You need
to create the repository and populate it, then connect to it before
you can connect to your database via the D2k front end.
Creating the repository is platform specific so you will need to blow
the dust of that IUG documentation.

Eugene (Oracle Certified dba looking for a job on NT or VMS).
=====================================

Quote:

> I am fairly new to Oracle 8 as well as Designer 2000.
> I installed Oracle 8 Enterprise on my laptop and had the Oracle
> Installer also install the pre-seeded database for me (I figured I
> needed a database for Designer 2k to use).

> When I tried to start Designer 2000 I used the SYSTEM/MANAGER
> id/password but D2K states that I cannot use SYSTEM.

> So, using Enterprise Manager GUI I created my own userid with the
> appropriate roles/priveleges (I thought).  But I still cannot get passed
> the Designer 2K login screen.  It tells me that it cannot connect to the
> repository and that my userid/password is bad/wrong.  

> I have been trying/creating various id's but without success.

> Can anyone help me here as to what I need to do and how to create a
> correct user id/password for D2K to work?  Do I need to create my own
> database rather than trying to use the pre-seeded Oracle 8 database, and
> if so, how?
> I'd appreciate a quick walkthrough as to the correct way to
> create/authorize a new user (which ID to use to create) as well as how
> to login to D2K with the new userid (i.e. enter anything other than the
> userid/pw on the login popup?).

> Thank you.

> Walter



Thu, 21 Jun 2001 03:00:00 GMT
 Can't login to Designer 2k with any id/password?

Apart from the answers already posted on how to find and modify the user and
password,
it is documented in the Designer installation guide (which I downloaded from
metalink):
the instance is called D703, and the repository owner is called repos,
password is manager.

Good luck!

PS Update to 2.1.1 (x.x.21 in component versions) asap...

  f.van.bortel.vcf
< 1K Download


Sat, 23 Jun 2001 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. ODBC doesn't use DSN Login ID/Password for SQL

2. Implementing Password Expiration of SQL Server Login IDs/Standard Security

3. Unable to assign password for sa login id

4. Create a login ID and do not encrypt the password with SQL 2000

5. Implementing password expiration of SQL server 6.5 login IDs

6. How to handle application Login ID/Password (storage)?

7. Seeking list of login id's with write permission on a table

8. Trouble removing Login ID's in SQL65

9. Trouble removing Login ID's in SQL65

10. sql database restore and login id's

11. Dropping Login Id's w/o dropping the users

12. Accessing LAN login ID's


 
Powered by phpBB® Forum Software