Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Permissions question - ALTER SCHEMA

Posted on 2013-11-27
2
Medium Priority
?
349 Views
Last Modified: 2013-11-29
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?
0
Comment
Question by:YZlat
2 Comments
 
LVL 10

Accepted Solution

by:
PadawanDBA earned 1000 total points
ID: 39681463
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.

Function: http://msdn.microsoft.com/en-us/library/ms186755(v=sql.105).aspx

SP: http://technet.microsoft.com/en-us/library/ms187926(v=sql.105).aspx
0
 
LVL 35

Author Closing Comment

by:YZlat
ID: 39685394
Thanks!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question