SSMS permissions

#1

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

#2

What permissions do you have in the database?

-Sue

On Wed, 15 Aug 2007 14:51:54 +1000, "Rotsey"
<malcolm_smith (AT) RemoveThis (DOT) optusnet.com.au> wrote:

Quote:

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

#3

Yes I see where they are

I click on the one I want

but there is no "Properties" in the right click menu

PLEASE HELP!!!

"Ekrem Önsoy" <ekrem (AT) btegitim (DOT) com> wrote

Quote:

Hi Rotsey,

I bet you are mistakenly trying to view System Stored Procedures'
properties. If you right click on a System Stored Procedure (which are
stored in Programmability\Stored Procedure\System Stored Procedures node)
then you'll see only "Modify", "Reports" and "Refresh" in the popup menu.

If you have stored procedures in your database, then they are going to be
stored in the Programmability\Stored Procedures node.

--
Ekrem Önsoy

"Rotsey" <malcolm_smith (AT) RemoveThis (DOT) optusnet.com.au> wrote in message
news:OjK09fv3HHA.1208 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SSMS permissions

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

SSMS permissions - 08-14-2007 , 11:51 PM

Re: SSMS permissions - 08-20-2007 , 07:46 PM

Re: SSMS permissions - 08-30-2007 , 12:02 AM