Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

scripting a database without db owner permissions Expand / Collapse
Author
Message
Posted Wednesday, February 16, 2011 10:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 21, 2012 10:18 AM
Points: 11, Visits: 115
I need to grant users the ability to script a database, but i cannot give them dbowner. Is there a way to do this?
Post #1065125
Posted Wednesday, February 16, 2011 11:50 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 11:43 AM
Points: 1,477, Visits: 2,100
Will granting VIEW DEFINITION permissions work?

Jason Shadonix
MCTS, SQL 2005
Post #1065185
Posted Wednesday, February 16, 2011 12:27 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 21, 2012 10:18 AM
Points: 11, Visits: 115
I have read in a bunch of places that this is supposed to work. When i give the user that privelege on the database (not server level) i get the following error:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Script failed for Database 'MIS333K_msbzz888'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1045+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Script+Database&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

Could not read metadata, possibly due to insufficient access rights. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1045+)&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
Post #1065221
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse