Re: grant execution permission

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 10/01/04

  • Next message: Eskimo: "Re: Granting login and access privileges to LocalSystem" 
    Date: Fri, 1 Oct 2004 06:41:21 -0500

    You can add the user to the database containing the proc and then grant
    execute permission to the user/role:

    USE MyDatabase
    EXEC sp_grantdbaccess 'MyDomain\MyUser'
    EXEC sp_addrolemember 'MyRole', 'MyDomain\MyUser'
    GRANT EXEC ON MyProcedure TO MyRole 

    -- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Farhan Iqbal" <anonymous@discussions.microsoft.com> wrote in message 
news:212d01c4a7a9$66756de0$a401280a@phx.gbl...
> hi,
>
> I want to grant execution permission to user which is
> residing in another database on same machine, how can I?
> Please help
>
>
> Thank you,
> Farhan Iqbal
>
  • Next message: Eskimo: "Re: Granting login and access privileges to LocalSystem"

    Relevant Pages

    • Re: Permission to Insert records for DB USERS
      ... To add to the response by Vyas, consider creating your own database ... EXEC sp_addrole 'Supervisors' ... GRANT SELECT ON MyTable TO Supervisors ... > I am a fresh developer for the SQL server and have no Idea> for the permissions on the database. ...
      (microsoft.public.sqlserver.security)
    • Re: ls --color
      ... You mount the shares with perms that allow execute permission for all ... I *think* the reason you can't change it by removing the EXEC color from ... EXEC to "00" in DIR_COLORS. ... Email replies to: ...
      (comp.os.linux.misc)
    • Re: ls --color
      ... You mount the shares with perms that allow execute permission for all ... I *think* the reason you can't change it by removing the EXEC color from ... EXEC to "00" in DIR_COLORS. ... exec perms through mount/samba options, or something, though. ...
      (comp.os.linux.misc)
    • RE: HTTP 500 - Internal server error - Internet Explorer
      ... Microsoft site), ... >To resolve this problem, grant the IWAM_ComputerName user ... account the Read & Execute permission for the Mfc42.dll ... >> Based on your network security settings they may ...
      (microsoft.public.inetserver.iis)
    • Re: Permission denied
      ... It's generally best to grant permissions only to roles and then control access via role membership since this simplifies administration. ... Some of the users running this app are ... EXECUTE permission denied on object ... ...
      (microsoft.public.sqlserver.security)