read-only permissions except specific stored procedures Right now I have two databases behind my asp.net web application.  I'm using a single login to access both databases.  the login has full ownership of one database and read-only rights to the second database.  I'd like to set it up so that specific stored procedures from my main database can do update/delete operations on the second database.  This way I can control the exact update/delete operations that are happening.  I've been having a hard time figuring this one out, any advice would be appreciated.
You can create a second user with elevated priviliges and use WITH EXECUTE AS 'username' clause in the stored procedure body, having the procedure executed as the user with readonly permissions would be elevated to the second user who can perform modifications to the second database.

In order for this to work you will also have to grant IMPERSONATE permission to the readonly user and to set a trust relationship between databases - this can be done in at least one of two ways: 
ALTER DATABASE &lt;dbname&gt; SET TRUSTWORTHY ON
(which might impose some security issues)
or the second option to use certificates to authorize user. This link might be helpful (it's written in the context of Service Broker, but the idea is the same considering security): LINK