Row/record level security

Srivas

hi,

I like to implement a record level security solution. (Nav2009 Sp1/ SQl Server 2008).
I donot want to use standard security filter feature as it won't be feasible.
I would prefer to create a new user setup permission table. Any Ideas?
filter should be working at all levels like document,posted docs, ledger entries,validation etc.

example : Patients table. Doctor A should only be accessing his patients list/data.

I have also noticed that there is a feature in SQL Server but I donot know how to implement and whether it will work?
any help much appreciated.

Many Thanks,
Srivas

rhpnt

Take a look at how responsibilty centers work - maybe it suits your needs. Implementing anything else requires a real NAV expert and lots of carefull work...

Savatage

http://www.lanhamassoc.com/downloads/gl ... Global.pdf

Security Management
Security Management provides you with the ability to establish field level security by specifying any field in the table as Visible, Hidden, or Visible but not Editable, for a specific user or group of users. All forms in NAV, including custom forms, will inherit the settings placed at the table level.

Srivas

Thanks Savatage.

But does this software works with NAV2009 (RTC)?
how much it will cost?
is there any other software available?


Thanks again.

[Responsibility center solution won't work with the requirement we have as it uses single value filter and doesn't work on historical document]