SQLTeam.com | Weblogs | Forums

Permissions question


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


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.