Questions tagged [impersonation]

Switching the current security context of a process to that of another account / login / user. This switch is a full replacement of permissions for the current process. This is usually achieved by using EXECUTE AS in SQL Server, RUNAS in Windows, su in Unix, etc.

Filter by
Sorted by
Tagged with
5
votes
1answer
4k views

Stored procedure security with execute as, cross database queries, and module signing

I have a situation that, while I was able to work around it (as the repro will show), I don't understand. Here are the high points Two databases, ChainingSource and ChainDestination, both of which ...
4
votes
1answer
297 views

Execute Permissions for a Store Procedure that creates databases

I have a Stored Procedure that creates a Database for a specific project which needs to run every month by one of our Data Analysts. The question is how do I structure this to enable the Analyst to ...
1
vote
1answer
2k views

SQL Server Impersonation is just NOT working

I simply would like a very limited user, in its own database, to call an update procedure on our database to tell us that it has updated a table, which it has access to. I have allowed the user ...