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 |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2010-12-24 : 05:11:55
|
| i have a create a user login to sql2005 to specific folowing rights1) USER only see one database2) user only see three table in this database, it only select, not insert, delete or update this recordsso how can create user to matching this scenario |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-12-24 : 05:57:24
|
One way I am aware of:quote:
USER only see one database
You can deny him view on other databases.quote:
user only see three table in this database, it only select, not insert, delete or update this records
You can deny insert,delete or update permission for selected tables. |
 |
|
|
|
|
|
Create New user to specific right in sql2005