SSMS permissions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Rotsey" <malcolm_smith@xxxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 15 Aug 2007 14:51:54 +1000

Hi,

I am trying to view the permssions for a stored proc in SSMS 2005

I go to programmibility, stored procedures, then right click on sp
but there is n o properties in the context menu.

please help??

rotsey

.

Follow-Ups:
- Re: SSMS permissions
  - From: Ekrem Önsoy
- Re: SSMS permissions
  - From: Sue Hoegemeier

Prev by Date: Re: Changing Object Explorer Details Window
Next by Date: Ce client connection.
Previous by thread: Incorrect syntax near the keyword 'open'.
Next by thread: Re: SSMS permissions
Index(es):
- Date
- Thread

Relevant Pages

Re: Newbie: Stored Procedures and Or Datasets ?
... > be a concensous that Stored Procedures are the most effective means to ... > mena less database access, can be optimised by the DBMS or Database ... you can use Stored Procedures just as easily as Dynamic Sql - in it's ... statement is virtually identical to calling a stored proc. ...
(microsoft.public.dotnet.framework.adonet)
RE:Any way to debug using SQL SP
... I am a newbie to QA debugger. ... with stored procedures. ... I have created a following stored proc which in turn ... Basically my intention is to debug the user ...
(microsoft.public.sqlserver.server)
Re: Language Features Id Like To See
... there should be a rule that no stored proc or trigger should be ... > allowed to call another stored proc. ... Our application has stored procedures calling other stored procedures. ... This allows customers to write their own custom code separate of our ...
(borland.public.delphi.non-technical)
Re: Brackets and special characters -- Brain Teaser
... You might be able to script out the Stored Procedures and do a search ... > The system is designed to use temp tables. ... I am guessing this design was for a stateless ... stored proc. ...
(microsoft.public.sqlserver.programming)
SSMS changing permissions on sp
... I am trying to view the permssions for a stored proc in SSMS 2005 ... I go to programmibility, stored procedures, then right click on sp ...
(microsoft.public.sqlserver.tools)