View Diagrams

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Re: SQL Server 2000 and diagrams...

Is there a way to change the view permissions for database diagrams?

We have multiple people who work on our databases, but the diagrams seem to
be viewable only by the person who created them. Is it possible to make
these viewable by other people with dbo access to the database?

It would save us having to create our own for each developer (we work in
remote locations so we cannot share paper copies either.)



.



Relevant Pages

  • Re: Beginning C# Q
    ... What is a typical method for handling multiple ... when the user submits changes to the database that the users ... > Groups table, which defines which Groups users belong to, and a Permissions ... That is why an Interface is called an Interface. ...
    (microsoft.public.dotnet.framework)
  • Allowing Multiple users to open the front end
    ... So if I am understanding everything correctly the only way to allow multiple ... users to open a "Microsoft Access 2007 Front End" is to allow all users full ... permissions I must convert the database from .accdb to .mdb and loose the ...
    (microsoft.public.access.security)
  • Re: Report of the Best Practice Analyser
    ... the constraints will go as well. ... This table gets created when you create database diagrams in a database. ... > Vyas, MVP (SQL Server) ...
    (microsoft.public.sqlserver.tools)
  • Granting SELECT to role on multiple tables
    ... I am trying to grant SELECT permissions to a server role ... on multiple tables within a database, ... it can't have SELECT on all tables in the database. ...
    (microsoft.public.sqlserver.security)
  • Want to be able to create or view database diagrams
    ... Our MS SQL DBA has database privileges locked down ... create our own database diagrams. ...
    (comp.databases.ms-sqlserver)