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 |
|
boreddy
Posting Yak Master
172 Posts |
 Posted - 2008-11-11 : 02:06:42
|
| is the any option to to restrict the records in a table it means in my table i want restrict the recorts(50 records)if i want i can change restriction only myselef only |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-11 : 02:08:18
|
| one way to do this is to create a view from table which fileters out the records you want. Then give only select permission on view for others. This will make sure they wont have access to records you filtered. |
 |
|
|
boreddy
Posting Yak Master
172 Posts |
Posted - 2008-11-11 : 02:15:08
|
| here is i am going to give database to our customer with all previleges some of the tables are restricted tables for the clientby analysing the tables they may do some changesi need to restriction those tables |
|
|
|
|
|
|
security issue