Re: Stored Procs in SQL 2005



Try:

GRANT EXEC on MyProc to AnotherUser

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Arne Garvander" <ArneGarvander@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3A650EF6-4C18-4715-A56E-15DB5D17D055@xxxxxxxxxxxxxxxx
How do i give execute privileges on stored procedures to an account?
--
Arne Garvander
Certified Geek
Professional Data Dude

.



Relevant Pages

  • Re: isDirty
    ... That flags works well unless I reformat what the operator entered. ... Arne Garvander ... Professional Data Dude ... check for a control of type equal to your text box subclass (the former is ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: Active Directory
    ... Blank for server seems to have connected to something. ... Arne Garvander ... Professional Data Dude ... Co-author of "The .NET Developer's Guide to Directory Services Programming" ...
    (microsoft.public.windows.server.security)
  • Re: Active Directory
    ... Arne Garvander ... Professional Data Dude ... "Jack Black" wrote: ... Is there a light weight utility that allows me to display Active Directory ...
    (microsoft.public.windows.server.security)
  • Re: Convert SQL Account to Windows Accounts + EXEC on ALL SPs
    ... I have an SQL Server 2000 Database that has an "SQL Account" that has ... execute permission on all Stored procedures. ... This one account is used by "all workstations". ... I want to fix this and use Windows Accounts, and get rid of that SQL ...
    (comp.databases.ms-sqlserver)
  • Re: isDirty
    ... Arne Garvander ... Professional Data Dude ... There is a modified property that I can use, ... anything into a textbox on a windows. ...
    (microsoft.public.dotnet.framework.windowsforms)