Re: Need to create a highly secured database
Posted in 1997
jmj22026@glaxowellcome.com wrote: >There is no need to buy anything extra to do this >job. You can use roles to do everything needed. Rubbish. Roles won't give you row level access control as requested in the original posting. He would have to use roles in conjunction with views to achieve the level of access that he requires. Fortunately he has only got a few tables so the pain of maintaining the view definitions won't be too bad. Regards, -------------------------------------------------------------------------- - Bruce Horrocks EASAMS Limited (...but speaking for myself) Waters Edge,Riverside Way,Watchmoor Park,Camberley,Surrey,GU15 3PD,UK Tel:+44 1276 686777 Tel:+44 1276 693043 (direct) Fax:+44 1276 686623 X400: S=HORROCKS,G=BRUCE,I=B,O=EASAMS LTD,P=GEC MARCONI,A=ATTMAIL,C=GB Mailto:Bruce.Horrocks@gecm.com -------------------------------------------------------------------------- -