sql server - What TSQL gives rights to create functions on a schema -


i have program runs following sql:

create function [foo\bar].something ( 

the sql looks fine, error

the specified schema name "foo\bar" either not exist or not have permission use it. 

what sql can run on database schema access create function? think want keep default schema dbo , have access other [foo\bar] schema.

the sql server books online states in create function topic (https://msdn.microsoft.com/en-us/library/ms186755.aspx):

requires create function permission in database , alter permission on schema in function being created


Comments

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

javascript - jQuery date picker - Disable dates after the selection from the first date picker -