Re: AUTHID Change Script

From: William Robertson <william_at_williamrobertson.net>
Date: Sat, 9 Apr 2016 09:52:18 +0100
Message-Id: <71127EAF-1B95-4C0C-9571-CDC474108BAA_at_williamrobertson.net>

Assuming these are in source control, it shouldn't be hard to do in one shot in a text editor. For example on Vim, look at "bufdo".

If they're not in source control, I'd say that needs to be part of the solution.

On 8 Apr 2016, at 23:22, Lange, Kevin G <kevin.lange_at_optum.com> wrote:

Evening all;
  I was wondering if anyone out here might already have a script to change the authid from definer to current_user on all Procedures, Functions, types, and packages that exist in a database with an AUTHID of definer?  

We find that we have a number of these in multiple databases and instead of opening them up by hand and editing every one of them, I was hoping for an existing script/procedure that could to that for us.  

Oracle Version: 10.2.0.4  

Appreciate any help.  

Kevin

This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Apr 09 2016 - 10:52:18 CEST