Creating procs with object priviliges granted through roles...

From: Yosi Greenfield <yosi_at_comhill.com>
Date: Wed, 20 Sep 2000 14:46:05 -0400
Message-Id: <10625.117485@fatcity.com>

Hi All,

Was there anything in the latest versions of Oracle that permits creating procedures that reference objects that have been granted to the creator only through a role? How do you create procedures as system that reference the data dictionary views? Do you grant them all specifically? One by one or en mass?

Thanks, as always,

Yosi

---

Yosi Greenfield
Database Architect
Comhill Systems, Inc.
yosi_at_comhill.com Received on Wed Sep 20 2000 - 13:46:05 CDT