Permissions question - ALTER SCHEMA

What type of permissions does the user need to be able to create a function or stored procedure within dbo schema (user default schema)? Would ALTER SHCEMA do the job?
LVL 35
Who is Participating?
PadawanDBAConnect With a Mentor Operational DBACommented:
Alter permissions for the dbo schema and create procedure permissions for stored procs.  Functions also require alter permissions on the dbo schema and create function permissions.  If the function specifies a user-defined type, requires EXECUTE permission on the type.


YZlatAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.