locked
grant execute permission to stord proc for user setup on inital DB server creation RRS feed

  • Question

  • When I setup my SQL Azure DB it asked for me to create a login, which I did. Now I need to give that users execute permission on some stored proc but when I run

    GRANT EXECUTE ON ELMAH_GetErrorsXml TO MyUser;

    I get the error
    Cannot find the user 'MyUser', because it does not exist or you do not have permission.

    If I look under Security -> Users I do not see my user listed I only see dbo, quest, INFORMATION_SCHEMA, and sys.

    Friday, July 25, 2014 2:10 PM

Answers