Re: DESIGNER - CREATE APPLICATION SYSTEM

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 Fri Sep 29 2000 - 21:33:04 CEST