How to grant insert in a table that is in another database on SQL Server 2008 R2?
fonte: https://dba.stackexchange.com/questions/96629/how-to-grant-insert-in-a-table-that-is-in-another-database-on-sql-server-2008-r2
Use [DatabaseA]
GO
ALTER DATABASE [DatabaseA]
SET DB_CHAINING ON
GO
Use [DatabaseB]
GO
ALTER DATABASE [DatabaseB]
SET DB_CHAINING ON
GO
EXEC sp_grantdbaccess 'UserB';
GO
GRANT SELECT, UPDATE on [DatabaseB].[dbo].[TableA] TO [UserB]
GO