adding users with des 2k - further problems

Thanks for the help but to no avail. (and yes I have throughly tried things in the manual)

[Quoted] I have noticed however that if I connect with SQL PLUS and do the folowing query select table_name from all_tables where owner is 'repos' i get a different # of results with repos and the user i am trying to create.

USER = 9
REPOS = 138 THE TABLES repos can access are:
CDI_DFLT_USER_PREF_USAGE
CDI_LANGUAGE_DEFINITIONS
CDRF_TMP_TBL
CDRK_TMP_TBL
CK_TEMPORARY_SET

REF_VALUES
SDD_ELEMENTS
SDD_RESERVED_NAMES
SDD_STRUCTURE_ELEMENTS

i am not sure if the above is particularly relevant.

i also tried creating a new application system and new user just to see if that particular repository was flawed but i get the same error.

My new user has the following system priviledges: CREATE SESSION
ALTER SESSION
CREATE TABLE
CREATE VIEW
CREATE SEQUENCE
CREATE PROCEDURE
CREATE TRIGGER
CREATE CLUSTER
CREATE SYNONYM
CREATE ANY SYNONYMN
CREATE DATABASE LINK
CREATE ROLE
CREATE SNAPSHOT [Quoted] Can anyone shed some light on this ??

In article <70d30j$f0c$1_at_nnrp1.dejanews.com>,   krose_at_cs.mun.ca wrote:
> Im running Oracle Enterprise Server 8.0.4.0.0 and the latest version of
> Designer 2000.
>
> I have the thing up and runinng so that I can connect from the client machine
> using repos/manager and work with my application system. Now im trying to add
> other users by:
>
> 1. I did a create like on the server end to create a user testuser/welcome
> from user repos. This is probably my mistake - im not sure hw to create a
> user witht he required roles privledges for des 2k.
>
> 2. From repository admin utility I added this user and reconciled.
>
> 3. From repository navigator I granted this user all permissions to
> application system.
>
> Whn I try to connect as testuser/welcome I get a CDI-20039. I think prob is in
> step in that I dont know how to create the proper user in Oracle.
>
> Can anyone help me. thanxs
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 22 1998 - 18:27:18 CEST