Tech Off Thread

2 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

Granting Execute permission's in Sql 2000 to AD users

Back to Forum: Tech Off
  • User profile image
    phreaks

    I have a proc that I want to grant an AD user Execute permissions on.

    I can't seem to figure it out.

    The user is myCompany\myUser

    If I try


    GRANT EXECUTE ON spMyProc TO myUser
    Go

    I get an error that the user doesn't exist.

    If I try
    GRANT EXECUTE ON spMyProc TO 'myCompany\myUser'
    Go

    I get an incorrect syntax error.

    Help?

  • User profile image
    phreaks

    Note to self...

    Make sure the SPELLING of the USER is correct in the future.

    my bad.

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.