RE: AUTHID Change Script

1. There are multiple databases with not all the same procedures/functions/packages/types on them
2. No source control library
3. Need automated process that can be ran as an upgrade on multiple databases. Hence we were looking for a procedure we can run against the database..

Source control is coming, but not here yet. That’s a completely different issue.

From: William Robertson [mailto:william_at_williamrobertson.net] Sent: Saturday, April 09, 2016 3:52 AM
To: Lange, Kevin G
Cc: Oracle-L_at_freelists.org
Subject: Re: AUTHID Change Script

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<mailto: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.

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