Re: 'insufficient privileges' from DBMS_SQL.PARSE call

In article <7f4uj4$j9j$1_at_nnrp1.dejanews.com>,   fanda_at_bigfoot.com wrote:
[snip]
> I got the same problem, and execute priv. on DBMS_SQL doesn't help. The

As another poster pointed out, the problem has to do with roles. Roles are not active when a stored procedure is executed, so the privileges assigned to a role don't count. You have to explicitly do something like:

grant CREATE VIEW to <owner>

Where <owner> is the login name under which you want to execute the procedure. Of, course, you have to have 'grant' privileges, or find someone who does...

--
Howard Lee Harkness

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 15 1999 - 17:54:49 CDT