Home -> Usenet -> comp.databases.oracle -> Designer 2000 problem

Designer 2000 problem

From: Mr. Chow Wing Siu <wschow_at_Comp.HKBU.Edu.HK>
Date: 1998/06/01
Message-ID: <6kt8uo$em6$1_at_power42t.hkbu.edu.hk>#1/1 







Hi, I recently find the repository owner lost the privileges required.



I manually use SYS a/c to do:



grant des2000_owner to repos_owner;


grant execute on dbms_lock to repos_owner;
grant execute on dbms_pipe to repos_owner;



Afterwards, the repository owner still cannot access admin utility:



    
  
  1.   Maintain Users
  
  2.   Privileges Objects & Parameters - Object Status and Object Sizes
  
  3.   User Extensions






What privileges that loose or how to fix this problem?



Thanks in advance.


-- 
Johnson Chow


Received on Mon Jun 01 1998 - 00:00:00 CEST












Original text of this message