Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-03-25 : 07:13:08
|
| Sandeep Patel writes "hi ! i want to give password to my database and its included tables same as that i can give inot access . plz help me. is this possible . i will wait for ur valuable reply." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-25 : 07:15:05
|
| Passwords are only given to SQL Server logins. Restricting access to certain tables or databases is done by GRANTing or DENYing access and permissions. See Books Online under "GRANT" for more information, also look at "sp_grantdbaccess" and "sp_adduser". |
 |
|
|
|
|
|
I want to give password to database and table also.