User rights

Hello oracle gurus,

    Using oracle 8i to publish a website, I have 2 users (ctxsys, and jimbob) which each own some of the objects(stored procedures). Jimbob owns most of the objects, although ctxsys owns the main page. How do I grant priveleges to a user so they can access both of the objects created?

    When I started working on the site (using jimbob) I could access all of the procedures, but when I logged in as ctxsys and recompiled the main page, I was no longer able to access the main page when I logged in as jimbob. Why is this?

    All help is greatly appreciated, thanks! Received on Wed Jun 28 2000 - 00:00:00 CEST