Stored Procedures and Roles

I was tasked with coming up with a version control methodology for stored procedures. The solution I came up with involves calling a procedure and passing it the version to run. This procedure then creates synonyms to the correct packages.

I got this to work but only after discovering that stored procedures do not get any system privileges from roles. I was using my personal schema which has the 'create any synonym' and 'drop any synonym' system privileges. When I got the package working it was moved into a schema that has the DBA role. I kept getting insufficient privilege errors. I got the DBA to grant the 'create any synonym' and 'drop any synonym' privileges to the schema. Now everything works fine.

We are running 7.1.4 on a Silicon Graphics system. Is this a bug or a feature of stored procedures?

-- 
Ed Bruce
edward_at_igate1.hac.com
Key fingerprint =  62 8D FC 8F 27 2F 89 D0  8B 38 7E 34 33 74 C2 36