Trigger for insert problem

I'm using mssql server 2008 and having a problem with a trigger. Now, i have this aspx page, which has a stored procedure working in a button click, and that stored procedure has an execute permission for the user, lets says "x". this procedure insert some values to a table on one db. and that table has a trigger for insert, which should insert those values to some tables at other databases.

As i said, th开发者_如何学Pythone stored procedure has an execute permission for the user "x", and the same user have insert/update/delete/select permissions on the tables that the trigger should do the insert to.

But when someone with an "x" permission starts the procedure, he/she gets this exception message : Cannot find the object "DatabaseName..table_name" because it does not exist or you do not have permissions.

But i know that database and table name is correct.

So i am thinking, maybe it has something to do with the table having permissions but i am not sure of course.

Any help with be appreciated, thanks.

Maybe you have same tables with different schemas? Your message doesn't indicate schema used. Or your user has not other database access right? It is actually possible that user has rights to table, but his access to database itself is disabled.