Row/record level security

Srivas
Srivas Member Posts: 89
edited 2011-11-24 in NAV Three Tier
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

Comments

  • rhpnt
    rhpnt Member Posts: 688
    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
    Savatage Member Posts: 7,142
    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.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • Srivas
    Srivas Member Posts: 89
    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]

Categories