SQL Server Authentication vs Windows Authentication
- by Nandu
Hi, I am a SQL Server newbie and would really appreciate any help.
I have created a new login (test2) with sql server authentication and granted select & vierw definition permission on another schema (test1) to test2. I am however not able to see the objects of test1 in the object explorer. However I can select the objects from the Query Window.
Since this new login is being used to develop reports the user would like to view the objects in the Object Explorer.
Another user test3 created using windows authentication and similar permissions is able to see test1's objects in the explorer.
Please let me if this is the cause and if not how can help test2 see the objects in Object Explorer.