Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thomadma
Starting Member
8 Posts |
 Posted - 2004-04-05 : 10:58:50
|
| Hi,I believe that database diagrams can only be created by members of the sa or dbo role. Is that correct? I need to verify because I have a group of developers needing to create a diagram on a production server and they are unable to. The best I can determine is it's a permissions-related issue.Maria |
|
|
MuadDBA
628 Posts |
Posted - 2004-04-05 : 11:13:04
|
| Then I'd say your security is working well. Developers really have no business on your production system. If they want to make a DB diagram, script the database for them and have them put iton a developer box and build the diagram there. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-05 : 12:25:30
|
| Our developers can't even get into the production server room, let alone log into production. If they need to look at the data or troubleshoot anything, a DBA logs them into the system and watches everything that they do. The developers can log into production through the application like any other users just not directly into the servers.Tara |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-04-06 : 08:12:21
|
| Hell I am the DBA and I can't even get into the server room without stopping off at the security office first. :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-06 : 12:12:21
|
| You should see our server room. Due to homeland security initiatives, I have to pass through 3 separate doors. The first door we call the teleporter. It's a man hole that allows one person at a time. You swipe your card. Glass doors open. You get inside but can't go anywhere cuz there are doors directly in front of you now. The doors close behind you and then the doors in front of you open up. I don't know what the second door is for. The third door is the actual server room. All 3 doors require you to swipe your card. The first one is observed by security. Tara |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-04-06 : 16:13:36
|
| Tara, you get ALL the cool toys!--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-04-07 : 10:06:58
|
| That sounds like some sorta spy movie stuff. |
|
|
|
|
|
|
Creating Database Diagrams - Sql 2000