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
Post a Comment