Grant Permissions Within Report SP Leaving aside why one would want to do such a thing:

In MS SQL Server 2008, Is it possible to have a report SP grant permissions to a column used in that report to a table in a database other than the one it's running in?

I'm looking at something like the following:

USE mydb
CREATE PROCEDURE dbo.report 
AS
BEGIN
GRANT SELECT ON otherdb.dbo.table (column) TO [myuser]

SELECT * from otherdb.dbo.table
END


Execute cannot be used on objects in a db other than the current one and USE statements cannot be included within a stored procedure. Is there another way?
Assuming the same user exists in both databases:

EXEC otherdb.sys.sp_executesql N'GRANT ...';


Of course you grant SELECT on a column, not EXECUTE.