Read a lot of information on the Internet is empty to talk about, all just say very simple, and then did not say encounter such a situation specific how to do, see here all know is the authority problem, in fact, each of us know, is I think I still want to give a friend after meeting a solution:
The database used here is version 08, and this has been reported as a permission error: the error is as follows:
See the effect Description: In the case of Windows authentication log in to the database table can be opened, when the switch to SA or another account login in the time we click on our database will be error:
Here's how to fix it:
1, first we have to use the Windows identity login to set up, because your SA and other account login settings are invalid "This step is very important."
2, find the corresponding library security---the framework->dbo-> right-click Properties "Permissions", Search, "public", OK, on the right with authorization, if you do not know the case of all the hook can be. Refer to the following:
3, if this time still use SA or other account can login, go in after right-click Edit Table Error, then this time you need to make the following settings.
4, Windows login to select Table Right-click Properties "Permissions", Search, browse "public", OK, on the right with authorization, if you do not know the case of all hook can be. Refer to the following
Finally the perfect solution to the problem. The effect is as follows:
Perfect solution, off duty.
SELECT permission denied to object ' base_config ' (database ' * * * ', schema ' dbo ')