Home > IT Answers > SQL Server > Access Rights in SQL Server 2005
ENGG666
15 pts.
 Access Rights in SQL Server 2005
SQL Server 2005, SQL Server permissions, SQL Server User Accounts, Windows Vista
Hi,  I'm using sql server 2005 and in my application i have 2 DB say A and B , and 2 servers SR1,SR2 and DB A,B and present on both (SR1,SR2).now i want to give access to users entering my DB not to view any of the entries made in the DB, not even the Tables created in my DB...pls provide me Step by step what methods i need to follow for this.. Vasee

Software/Hardware used:
SQL SERVER 2005
ASKED: January 7, 2010  6:29 AM
UPDATED: January 7, 2010  1:43 PM
RELATED QUESTIONS
Answer Wiki:
By default users won't have access to any objects. If the user doesn't have access to query a table then they will not be able to view the table.
Last Wiki Answer Submitted:  January 7, 2010  7:16 am  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _