SQLTeam.com | Weblogs | Forums

Permissions question


#1

How do I know what permission needed to create a Scalar-valued UDF in master database?


#2

From MSDN, "Requires CREATE FUNCTION permission in the database and ALTER permission on the schema in which the function is being created. If the function specifies a user-defined type, requires EXECUTE permission on the type."

Permissions required should be the same even if it is the master database.