Oops, something did go wrong, as it turns out that if you try to grant permissions on extended stored procedures, which SPEES is, you need to do it from the
masterdatabase. Cool, let us switch to master and do it there. Well, if you try to do that – then you get another error: the user does not exist in
At this stage you have a couple of options:
Add the login for the user to theNo do not do that, I am only kidding! Do.Not.Do.That!
sysadminrole, or the user to the
db_ownerrole in the actual database.
Create the user in
masterand grant the permission. That would work.
Grant the permission to
Check it out, as there are two parts to the process.