MS SQL Server, Create SP as DBO

Create SP as DBO

Author	Message
Brian McPheeter #1 / 3	Create SP as DBO Is there anyway to create a stored procedure with dbo as the owner when you are not dbo?
Tue, 09 Dec 2003 04:48:59 GMT

Keith Kratochvi #2 / 3	Create SP as DBO (assuming that you have the appropriate permissions) CREATE PROC dbo.foo AS ........ -- Keith ============== Please reply only to the newsgroups. When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which can be cut and pasted into Query Analyzer is appreciated. Quote: > Is there anyway to create a stored procedure with dbo as the owner when you > are not dbo?
Wed, 10 Dec 2003 06:19:07 GMT

Dan Guzma #3 / 3	Create SP as DBO To expand on Keith's response, a user who is not the database owner needs to either be a member of the db_owner role or the db_ddladmin fixed database roles in order to create objects owned by 'dbo'. Hope this helps. ----------------------- SQL FAQ links (courtesy Neil Pike): http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (faqxxx.zip in lib 7) or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800 or www.sqlserverfaq.com or www.mssqlserver.com/faq ----------------------- "Keith Kratochvil" <Keith.please email only when Quote: > (assuming that you have the appropriate permissions) > CREATE PROC dbo.foo > AS > ........ > -- > Keith > ============== > Please reply only to the newsgroups. > When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which > can be cut and pasted into Query Analyzer is appreciated. > > Is there anyway to create a stored procedure with dbo as the owner when > you > > are not dbo?
Wed, 10 Dec 2003 13:27:34 GMT

Page 1 of 1

[ 3 post ]