Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER
Дата
Msg-id CAKFQuwaxggv7LZz7UCTR8Yri3K5d3J8RPA1BFuguRygL2agT_w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER  (Ron Johnson <ronljohnsonjr@gmail.com>)
Список pgsql-admin
Дерево обсуждения
On Tue, Jun 18, 2024 at 1:23 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
On Tue, Jun 18, 2024 at 3:39 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
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?

That's a pretty blunt club.  Changes the ownership of EVERYTHING, no? 

Maybe that is what is wanted, or is sufficient.  I found it plausible the OP simply was unaware of its existence and should make sure it doesn't actually meet their needs quickly and easily.

David J.

В списке pgsql-admin по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER