Re: Designer 2000 problem

Hi,

does your repos_owner have execute_any_procedure that is required?

and are all the synonyms still intact in their schema account?

regards

Rod Corderey

Lane Associates
Lane_Associates_at_Compuserve.com
http://www.Lane-Associates.com

Mr. Chow Wing Siu wrote:
>
> 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 Tue Jun 02 1998 - 00:00:00 CDT