RE: Unable to view all procedures in management studio

Hello Quinn,

This is secruity design change in SQL 2005. You could try this statments:

GRANT VIEW ANY DEFINITION TO public

Please see following article for more details:

http://www.microsoft.com/technet/technetmag/issues/2006/01/ProtectMetaData/d
efault.aspx

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================



This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
From: "Quinn" <dellsql@xxxxxxxxxxxxxxxxx>
Subject: Unable to view all procedures in management studio
Date: Wed, 8 Feb 2006 21:52:31 -0600
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
X-RFC2646: Format=Flowed; Original
Message-ID: <#flSCxSLGHA.740@xxxxxxxxxxxxxxxxxxxx>
Newsgroups: microsoft.public.sqlserver.clients
NNTP-Posting-Host: cpe-70-112-155-207.austin.res.rr.com 70.112.155.207
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.clients:31364
X-Tomcat-NG: microsoft.public.sqlserver.clients

I manage access to our databases via global group. All of the developers
on
my team are in this global group. In our testing environment I only grant
this global group read access to the database. In SQL 2000, even with this
limited level of access, users are still able to see all objects in Query
Analyzer. However in management studio none of the developers can see any
stored procedures. Even when querying sys.objects the information for the
procedures do not return. I have verified that there are no filters in
management studio. Does anybody have any idea what is going on?




.

Relevant Pages

  • Re: Unable to view all procedures in management studio
    ... This is secruity design change in SQL 2005. ... I manage access to our databases via global group. ... However in management studio none of the developers can see any ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL 2005 Management Studio/Express - Any differences
    ... I tried to copy the sql tools msi off the ... installation CD and install it on the developers machine but it will ... management studio but i can only find the management studio express ...
    (comp.databases.ms-sqlserver)
  • !!!Attention SQL Server 2005 Gurus :: Management Studio problems!!!
    ... I use Management Studio to develop/maintain a SQL Server 2000 database ... What is the equivalent Management Studio action for the following SQL ... SQL Query Analyzer 2000 has an option to "Script object-level ...
    (microsoft.public.sqlserver)
  • Re: Sql Mobil (SqlCE 3.0) and Full Framework
    ... Yes I'm using Sql2005 Management Studio with replication and that is the ... > SQL Mobile database. ... > would on the device *except* you bring in a reference to the desktop ...
    (microsoft.public.sqlserver.ce)
  • Re: Subscription to SQL 2000 from SQLX 2005?
    ... I am using Management Studio Express CTP, ... I'm working in a test environment where our license is for 1 processor, SQL ... least not according to the documentation, which says that SQL Server Express ... > selecting to push the subscription, the create subscription wizard of SQL ...
    (microsoft.public.sqlserver.replication)
Loading