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 |
|
WoodHouse
Posting Yak Master
211 Posts |
 Posted - 2010-02-12 : 10:01:42
|
| HI Pls help on this..How to use Row Level Permission...For example I have table, table having status columns..If status = 'Y' admin only view this records..IF status is NO some other user will access the records thankswood |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-12 : 10:07:34
|
| shouldnt this be a business rule that needs to be enforced at application?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
WoodHouse
Posting Yak Master
211 Posts |
Posted - 2010-02-12 : 10:21:46
|
| HIFor examplewe take it as Employee table..In employee table mine data , my junior data , VP data also...If I logined i can see mine data & my junior data..not VP If VP logined he has seen all the data...not his boss datalike that..how to restrict the data level...(row level) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-12 : 10:24:37
|
quote:
Originally posted by WoodHouse
HIFor examplewe take it as Employee table..In employee table mine data , my junior data , VP data also...If I logined i can see mine data & my junior data..not VP If VP logined he has seen all the data...not his boss datalike that..how to restrict the data level...(row level)
just restrict it in retrieval sp/querymake sure you retrieve only data for level passed and lower.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Login