Create view from table in external database with other usercredentials

Is it possibly to create a view 开发者_运维知识库of a table from another database on the same server, but with other usercredentials?

Any ideas how this could be done?

Using FEDERATED engine - your problem should be "easily" solved. A great article can be found at MySQL website.