Re: Designer 6.0 Pre-Production User Logins

Frank van Bortel wrote:

>> I have a running repository for Designer 6.0 [snip]
>> This seems to imply that only the repository owner can log into
>> Designer, [snip]
>
> A user cannot create or maintain an application - a manager must do
> that,
> and grant access to an application. The error message could be better?
>
> Either make the user a manager, or create a manager, setup an
> application system,
> and grant access to the user. I have no problem with my version
>

Frank,

Doesn't matter if I create the user as a vanilla user or a manager.  The
user is duly recorded in the repository but cannot log into it.  If I
create a new repository for the user, than nothing in the original
repository is available to them.  I didn't have this problem with older
versions of Designer so I suspect this is some aberation in the 6.0
pre-production release?

Jack

Still, it works for me...
Here's how I created the user:
CREATE USER D603
   IDENTIFIED BY D603
   DEFAULT TABLESPACE USER_DATA
   TEMPORARY TABLESPACE TEMPORARY_DATA
   QUOTA UNLIMITED ON USER_DATA;

GRANT DES2K_USER_ROLE TO D603;
GRANT CREATE TABLE, CREATE VIEW, CREATE SEQUENCE to D603;
These are needed expicitely, because dynamic sql is used... The Owner needs them as well!
The role is created with:
GRANT CREATE CLUSTER,
      CREATE DATABASE LINK,
      CREATE PROCEDURE,
      CREATE    ROLE,
      DROP ANY  ROLE,
      GRANT ANY ROLE,
      CREATE SESSION,
      ALTER  SESSION,
      CREATE SEQUENCE,
      CREATE SNAPSHOT,
      CREATE SYNONYM,
      CREATE TABLE,
      CREATE ANY TRIGGER,
      CREATE VIEW
TO DES2K_USER_ROLE;
GRANT SELECT ON SYS.DBA_ROLES         TO DES2K_USER_ROLE;
GRANT SELECT ON SYS.DBA_ROLE_PRIVS    TO DES2K_USER_ROLE;
GRANT SELECT ON SYS.DBA_SYS_PRIVS     TO DES2K_USER_ROLE;
GRANT SELECT ON SYS.DBA_ROLLBACK_SEGS TO DES2K_USER_ROLE;
GRANT SELECT ON SYS.DBA_SEGMENTS      TO DES2K_USER_ROLE;

Give it a try!
--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle

Work:                                Home:
----------------------------------   ----------------------------
V&L Informatica BV                   Hunzestraat 4
Palandijn 3, 7521 PN Enschede        7555 WB Hengelo
PoBox 545, 7500 AM Enschede          (31)074-2425046
053-4341500
  Received on Tue Aug 03 1999 - 00:32:36 CEST