About security Filter

anjann84

Hi all,

What is the role of Security Filter in the Permission???
How can we make use of this???
Give an examaple....

Thansk in Advance!!

kriki

It serves to filter records. But can only be used with SQL.

anjann84

can i get an example for how to implement it....

admoretutsie

Here is an example:
Create two users , give one super permissions and give the other only the role ALL and another role you create, say Cust)All to read/delete/modify table 18. but apply a filter, say Name starts with an S (S*).

Log in as the super user and view the customer list. Log in as the other user and view the customer list.

There yu are =D> !!

anjann84

Hi admoretutsie,

I tried out what you siad... but i could not view the Object Designer to view the customer list.... Where will I need to check for that??

kriki

anjann84 wrote:

Hi admoretutsie,

I tried out what you siad... but i could not view the Object Designer to view the customer list.... Where will I need to check for that??

Go to the customer card and hit F5 to see the list.

dynuser

kriki wrote:

It serves to filter records. But can only be used with SQL.[/quotHi.Should i make any configuration from SQL Server or only i should put the security filter from Navision Permission form

Thanks in Advance

Dynuser

vytjak

You only need to set the security filter in Navision.

dynuser

Should i do any synchronisation after setting the security filter and if yes? How to do do it?

10x

kriki

If you have the enhanced security model, you should do it (Tools=>Security=>Synchronize).
If you have the standard security model, you don't need to do it (it is best to use the standard security model anyway!).

pa_tou

Is it possible to use NAV security filter to allow user to view, edit , delete only base on location code or responsability center?