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.
精彩评论