Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can't Create Database Diagrams

In SQL 2008, Is it a way to grant permission to developer for view and create database diagrams without giving them dbo permission?

like image 278
mengchew0113 Avatar asked Nov 16 '10 04:11

mengchew0113


1 Answers

To take credentials to create db. Diagram, Try this query:

EXEC dbo.sp_changedbowner @loginame = N'sa', @map = false
like image 184
abdelrhman raafat Avatar answered Sep 23 '22 16:09

abdelrhman raafat



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!