Re: Unable to view all procedures in management studio

Hello,

Did you try on different database/new database? If you run "GRANT VIEW ANY
DEFINITION TO public", does it make any difference?

Also, do the SPs that cannot be seen has different schemes?

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>
References: <#flSCxSLGHA.740@xxxxxxxxxxxxxxxxxxxx>
<wG6fX8ULGHA.768@xxxxxxxxxxxxxxxxxxxxx>
Subject: Re: Unable to view all procedures in management studio
Date: Fri, 10 Feb 2006 15:38:37 -0600
Lines: 69
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
Message-ID: <u2KJdpoLGHA.3180@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!TK2MSFTNGP10.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.clients:31373
X-Tomcat-NG: microsoft.public.sqlserver.clients

Sorry. I forgot to mention that they can see some of the procedures but
not
all. Also when I try to use a SQL login which only has execute
permissions,
I can see some procedures ( but a different set of procedures ) but not
all.
Really weird.



"Peter Yang [MSFT]" <petery@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:wG6fX8ULGHA.768@xxxxxxxxxxxxxxxxxxxxxxxx
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

  • multiple domain access
    ... we have a global group of the ... sets up security and database access for the first SQL ... SQL creates the account, ...
    (microsoft.public.sqlserver.security)
  • Re: multiple domain access
    ... we have a global group of the ... > sets up security and database access for the first SQL ... Find the database you wish to grant access to, check the box, and then ...
    (microsoft.public.sqlserver.security)
  • Accessing sql server from a remote machine
    ... the database from machine 'B'. ... I have tried to add machine 'B' to our global group in order to ... give it access to our database, but we get errors on the SQL server. ... event viewer we see 18456: ...
    (microsoft.public.sqlserver.security)
  • RE: user permissions in a database as a whole or tables
    ... user permissions in a database as a whole or tables ... The way to give permissions to a user is a simple GRANT. ...
    (comp.databases.informix)
  • Re: user permissions in a database as a whole or tables
    ... like PDF better but that was not helping this time either. ... user permissions in a database as a whole or tables ... The way to give permissions to a user is a simple GRANT. ...
    (comp.databases.informix)