Re: Stored Procedures and Roles
Date: 1995/11/15
Message-ID: <48ddod$su_at_pipe3.nyc.pipeline.com>#1/1
On Nov 14, 1995 17:47:36 in article <Stored Procedures and Roles>, 'edward_at_igate1.hac.com (Ed Bruce)' wrote:
>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?
Yes, it is a feature. Supposedly a security feature. Don't ask me why.
Amy Received on Wed Nov 15 1995 - 00:00:00 CET