Re: DESIGNER - CREATE APPLICATION SYSTEM

Thank's! That was it. Now it work!

frank napisa³(a):

> Thought so ;)
>
> what you need to do is grant execute on some sys packages
> to the repository owner (*not* to a role, assigned to the
> owner, but to the owner!):
> You probably have to do this in svrmgr, connacted as sys (or internal):
> grant execute on sys.dbms_lock to <your repository owner>;
> grant execute on sys.dbms_pipe to <your repository owner>;
>
> That's the minimum, and documented.
> I learned to thow in execute grants on the following, too:
> SYS.DBMS_ALERT
> SYS.DBMS_SHARED_POOL
> SYS.DBMS_SQL
> SYS.STANDARD
> SYS.DBMS_STANDARD
> SYS.DBMS_TRANSACTION
> SYS.DBMS_UTILITY
>
> Grtz, Frank
> Krzysztof Kowalczuk wrote:
>
> > In the repository are two packages bodies (CK_UTIL, RMMAC) with status
> > 'INVALID'. I checked why those packages are invalid and I get an message that
> > an SYS.DBMS_LOCK is not declared.
> > What is SYS.DBMS_LOCK (what kind of type of objects). Can I create this
> > object myself or have I declare it and where. What have I do with that
> > problem?
Received on Mon Oct 02 2000 - 12:56:02 CEST