Re: How Do I give EXECUTE Permissions on Stored Procedures?

From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
Date: Thu, 20 Sep 2007 21:40:59 +0000 (UTC)

alvinstraight38@xxxxxxxxxxx (alvinstraight38@xxxxxxxxxxx) writes:

Ahh, I see now why I was lost. I right click on the SP, and there is
no option for Properties. Yet, I can set permissions on tables. How
stupid. You mention SP2. How can I tell which service pack I am
running? I went to Help - About and it shows:

Microsoft SQL Server Management Studio Express Version 9.00.2047.00

That's SP1.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

References:
- How Do I give EXECUTE Permissions on Stored Procedures?
  - From: alvinstraight38@xxxxxxxxxxx
- Re: How Do I give EXECUTE Permissions on Stored Procedures?
  - From: Erland Sommarskog
- Re: How Do I give EXECUTE Permissions on Stored Procedures?
  - From: alvinstraight38@xxxxxxxxxxx

Prev by Date: Re: Select statement help
Next by Date: Re: Delete or detach a Suspect database
Previous by thread: Re: How Do I give EXECUTE Permissions on Stored Procedures?
Next by thread: Select statement help
Index(es):
- Date
- Thread

Relevant Pages

Re: Unable to Install Embedded SP2 Database files
... Finally broke down and called MS. Ended up with an tech support guy who elevated the call to upper level since he couldn't figure out what was wrong. ... Basically the result is that I'm running SQL Server 2K with Service Pack 4 on an Active Directory Domain on Win2K Advanced SP3, ... Then installing XPE Database SP1 and then SP2. ... As far as I can tell, the Service Pack level/revision number could just be another "property" of the component. ...
(microsoft.public.windowsxp.embedded)
Re: Recent MSFT KBs on XP SP2 Incompatibility and Others
... I wish I could accurately distinguish what are SP2 problems (particularly ... > Some Programs Seem to Stop Working After You Install Windows XP Service ... > Troubleshooting Windows Firewall Settings in Windows XP Service Pack 2 ... > you install SQL Server 2000 or MSDE 2000 on a computer that is running ...
(microsoft.public.windowsxp.general)
Re: Recent MSFT KBs on XP SP2 Incompatibility and Others
... I wish I could accurately distinguish what are SP2 problems (particularly ... > Some Programs Seem to Stop Working After You Install Windows XP Service ... > Troubleshooting Windows Firewall Settings in Windows XP Service Pack 2 ... > you install SQL Server 2000 or MSDE 2000 on a computer that is running ...
(microsoft.public.windowsxp.customize)
Re: Recent MSFT KBs on XP SP2 Incompatibility and Others
... I wish I could accurately distinguish what are SP2 problems (particularly ... > Some Programs Seem to Stop Working After You Install Windows XP Service ... > Troubleshooting Windows Firewall Settings in Windows XP Service Pack 2 ... > you install SQL Server 2000 or MSDE 2000 on a computer that is running ...
(microsoft.public.windowsxp.basics)
Re: Recent MSFT KBs on XP SP2 Incompatibility and Others
... I wish I could accurately distinguish what are SP2 problems (particularly ... > Some Programs Seem to Stop Working After You Install Windows XP Service ... > Troubleshooting Windows Firewall Settings in Windows XP Service Pack 2 ... > you install SQL Server 2000 or MSDE 2000 on a computer that is running ...
(microsoft.public.windowsxp.newusers)