RE: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER
От | PABLO ANDRES IBARRA DUPRAT |
---|---|
Тема | RE: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER |
Дата | |
Msg-id | CPUP152MB40187B6AFA1563A62AC5DF0F87CE2@CPUP152MB4018.LAMP152.PROD.OUTLOOK.COM обсуждение исходный текст |
Ответ на | Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER ("David G. Johnston" <david.g.johnston@gmail.com>) |
Ответы |
RE: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER
|
Список | pgsql-admin |
Hi David,
Why do you say that reassined operation don’t work for me?
This operation is for assign an account for execute all modifications required over the environment.
Greetings
De: David G. Johnston <david.g.johnston@gmail.com>
Enviado el: martes, 18 de junio de 2024 15:39
Para: PABLO ANDRES IBARRA DUPRAT <Pablo.Ibarra@itau.cl>
CC: pgsql-admin@lists.postgresql.org
Asunto: Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER
On Tuesday, June 18, 2024, PABLO ANDRES IBARRA DUPRAT <Pablo.Ibarra@itau.cl> wrote:
Hi Dear Community.
I need your help with advices about the way to script a SQL command to generate a list of ALTER PROCEDURE and change owner of a big number of procedures.
As you know to identify the procedure or function is neccesary to add to the name of routine and list of parameters with their data type in each case.
Please any advice Will be appreciate.
Have you determined that “reassigned owned” won’t work for you?
David J.
ADVERTENCIA: E-Mail externo, favor verifique remitente, no descargue archivos adjuntos de remitentes desconocidos, no haga Clic en enlaces. Ante sospechas reporte a Seguridad de Información Itau seguridadinformacion@itau.cl
Вложения
В списке pgsql-admin по дате отправления: