Change UDF Owner

Can I change the owner of a UDF?

Example:

USE master
GO
EXEC sp_changeobjectowner 'fn_replgetagentcommandlinefromjobid', 'sa'

.... isn't working. I want dbo to own all the objects in my database - just
a security best practice sort of thing. I can't seem to find my answer
searching the web.


.

Relevant Pages

  • Re: Two Way Bidirectional Rep
    ... Let me post my entire script with what I did. ... use master ... exec sp_replicationdboption N'WEB_TSK_MGMT', N'publish', true ... "The process could not connect to server 'GRSSQL'. ...
    (microsoft.public.sqlserver.replication)
  • Re: Granting EXEC to all my user sprocs in one hit
    ... You can run the procedure below (after you have created it in master) in the ... Grant the EXEC privilege to these user-sprocs only (excluding the ... > I'm detaching the live copy and copying the files across to dev machine, ... > set the permissions. ...
    (microsoft.public.sqlserver.security)
  • Re: System sproc to channel to database(s)
    ... permissions in master. ... use northwind ... use pubs ... exec dbo.sp_MS_marksystemobject 'dbo.sp_insertSomething' ...
    (microsoft.public.sqlserver.programming)
  • Re: Description in the table
    ... EXEC sp_addextendedproperty 'caption', 'Employee Name', 'user', dbo, ...
    (microsoft.public.sqlserver.programming)
  • Re: Calling UDF on Linked Server
    ... > I'm trying to call a UDF on a linked server and I'm having issues! ... > Microsoft Knowledgebase Article KB319138 tells me that I can't call a UDF> in a four part linked server query. ... > Instead I have to use OpenQuery ... > ie exec Linked_Server.northwind.dbo.sp_executesql N'SELECT ...
    (microsoft.public.sqlserver.programming)