Oracle designer 6i

[yumi_rama]

I would like to start using Oracle designer 6i. could someone tell me what is the best way to start learn that.
I have installed the same on Windows 2000, with Oracle 8.1.7 server. But i cannot open the designer, it says
CDR-20043 - Non-versioned repository has no workarea or insufficient privilieges.

Could somebody help me out..

Rama

[dknight]

When you installed Designer, you should have created a repository. It is an Oracle database like any other in some ways.

You will need to create a user that has administrative privileges and owns the repository.

If you have installed Designer from the Technet download, it should prompt the creation of a repository and the creation of a user that is the repository owner.

Good luck.

[yumi_rama]

O yeah, It did create a repository.
But i made a user and granted connect, resource, create role and create procedure to it.
does the user need more privileges than this.


Rama

[dknight]

The owner of my repository is DESOWNER.

DESOWNER has the following roles:

connect
dba
resource
ck_oracle_repos_owner
ckr_desowner

ckr_desowner is granted with administrative rights.

Hope that helps.

[yumi_rama]

Hi,

I do have the ckr_desrep role, but what about the
ck_oracle_repos_owner. Did you create them, as i couldn't see that even in dba_roles view.


Rama

[shawish_sababa]

Hi

first, in order to prevent futur problems with ecp/imp add to you important users full exp/imp. also, in the designer 6i you have the repositpry tool where ou admin users, you create a db user and then you create the designer user, allthough i think it is not a must to first create the db user.

[dknight]

I did not create any custom roles. The DESOWNER user that I created was done when I set up the repository. The role was assigned by Oracle.

Here are two possible suggestions.

1) if you can get into Designer, try using the Repository Administration Tool to adjust privileges.

2) try to assign the privileges through the SQL*Plus interface with SYSTEM.

Good luck.