sql - Can't Create Database Diagrams -


in sql 2008, way grant permission developer view , create database diagrams without giving them dbo permission?

from books online:

to use database diagram designer, must first set member of db_owner role control access diagrams.

and

any user access database can create diagram

in other words, user db_owner permissions must first enable diagrams in database (to create sysdiagrams table) , can create them. see books online more information.


Comments

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

html - Instapaper-like algorithm -

c# - How to execute a particular part of code asynchronously in a class -