ORA-01933 role privileges error

From: Doug Cowles <dcowles_at_us.ibm.com>
Date: 2000/03/01
Message-ID: <38BD6925.9210C7@us.ibm.com>#1/1

In creating a view for a new user with NO roles. I noticed that part of the view
referenced a package owned by a different user. I created a synonym for hat
package, and re-ran the view code. Then I got Creating view ra_site_uses_allcai_v

                      arp_addr_pkg.format_address(addr.address_style,,

ERROR at line 246:
ORA-01933: cannot create a stored object using privileges from a role.

So, I granted explicit execute privileges and everything was fine. But,
this new user has connect and resource roles - what privileges from a role is it
complaining about? the new user doesn't have execute procedure so what gives?
Also what does it mean cannot create stored object - how is that related to executing
a package.

Thanks,
Dc. Received on Wed Mar 01 2000 - 00:00:00 CST