Re: Viewing database diagrams

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 04/19/04

Next message: Joe Celko: "Re: CASE ORDER BY Date sort"
Previous message: Steve Qian: "Java (JDBC) exception for already handled error from SQL Server Stored Procedure"
In reply to: TG: "Viewing database diagrams"
Next in thread: Michael, Cheng [MSFT]: "RE: Viewing database diagrams"
Messages sorted by: [ date ] [ thread ]

Date: Mon, 19 Apr 2004 17:44:29 -0600

For just viewing diagrams, grant execute permissions on
dt_getobjwithprop_u and dt_getpropertiesbyid_u.

-Sue

On 19 Apr 2004 13:30:01 -0700, tguillor@ems.jsc.nasa.gov
(TG) wrote:

>SS2000
>
>I added a user to a database. The user is in the public role, which
>has its original permissions. I did not give the user any explicit
>permissions. He cannot view an existing database diagram. How do I
>make it possible for him to view the diagram?
>
>thanks

Next message: Joe Celko: "Re: CASE ORDER BY Date sort"
Previous message: Steve Qian: "Java (JDBC) exception for already handled error from SQL Server Stored Procedure"
In reply to: TG: "Viewing database diagrams"
Next in thread: Michael, Cheng [MSFT]: "RE: Viewing database diagrams"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: change user1 access changes user2 access
... > Using the public role is your problem. ... >permission you are granting All users the permissions. ... I click on New Login. ... >> name, a password, I select a database to login to, then ...
(microsoft.public.sqlserver.security)
Re: change user1 access changes user2 access
... Using the public role is your problem. ... All users, whether it be User1, ... permission you are granting All users the permissions. ... > name, a password, I select a database to login to, then go ...
(microsoft.public.sqlserver.security)
Re: Newbie: I dont understand user permissions for table access
... > My database is remote to my workstation. ... > tables/fields WITHOUT specifying anything in the permissions dialogs? ... >> HOW are you connecting to SQL Server? ... what rights/permissions have been granted to the PUBLIC role? ...
(microsoft.public.sqlserver.server)
Re: Remove permissions in default Public Role?
... functionality. ... in a database or when connecting to a database server. ... You'd want to make sure you are not granting permissions to ... happening because of the Public Role in the Master db. ...
(microsoft.public.sqlserver.security)
Re: PUBLIC ROLE
... think of the Public role as being very much ... > If I create a database called "TEST" and make a user George database ... you grant those permissions to the public role. ...
(microsoft.public.sqlserver.security)