February 16, 2011 at 10:23 am
I need to grant users the ability to script a database, but i cannot give them dbowner. Is there a way to do this?
February 16, 2011 at 11:50 am
Will granting VIEW DEFINITION permissions work?
The Redneck DBA
February 16, 2011 at 12:27 pm
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
------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply