Re: Designer 2000 user name and password

You have to have an Oracle database on your computer (or accessible from your computer) and create an user that will own Designer (the Designer repository). I used the following script when I created an repository owner on my linux box, connect as sys, change the 'datafile' lines if you're running NT :

create tablespace DES2000
datafile '/p03/app/oracle/product/8.0.5./dbs/des2ora1.dbf' size 30M   autoextend on next 10M maxsize 60M
  default storage (initial 10K next 10K minextents 1 maxextents 121 pctincrease 50)
online;

create tablespace DES2000_IX
datafile '/p03/app/oracle/product/8.0.5./dbs/des2idx1.dbf' size 10M   autoextend on next 10M maxsize 40M
  default storage (initial 10K next 10K minextents 1 maxextents 121 pctincrease 50)
online;

create user repos identified by repo
default tablespace DES2000
temporary tablespace TEMP_DATA
quota unlimited on DES2000
quota unlimited on DES2000_ix

quota unlimited on USER_DATA
quota unlimited on TEMP_DATA
quota unlimited on USER_DATA

grant connect,resource to repos;

alter table SYS.IDL_UB1$ pctfree 0 pctused 50 storage (next 500K pctincrease 0)
;

alter table SYS.IDL_UB2$ pctfree 0 pctused 50 storage (next 500K pctincrease 0)
;

_at_D:\orant\repadm20\utl\ckrorole.sql

grant execute on dbms_lock to repos;
grant execute on dbms_pipe to repos;
grant select on dba_rollback_segs to repos; grant select on dba_segments to repos;
grant create sequence to repos;
grant create synonym to repos;
grant create table to repos;

grant des2000_owner to repos;

You then connect as repos and run the Designer administration utility first (this may take a long while...). Then you can access the repository.

Richard Cuello skrev i meldingen <36C606A7.D983161B_at_columbia.edu>...
>Anyone know the user name and password to log on to Designer 2000 I just
>installed on my computer?
Received on Sun Feb 14 1999 - 21:22:17 CET