Solution required on...............
Can we give specific objects (i.e. Tabel, View, Procedure etc....) access to a user in SQL Server 2005?
If yes then How?
I do not I want windows based authentication, I need SQL Server Authentication.
If a user has got access to table1, table2 as read only rights then I need whenever he/she loggin in database using SSMS, he/she should see only table1, table2 rest other objects should not be displayed to him/her. OR he/she can only be able to SELECT on table1, table2.
Thanks in advance,