Security Filters On Permissions

Kc_Nirvana

Hello....
I've searched the forum, and didn't find what i need....
I've a table with one field which is the userid of the person who entered in Nav.
In the permissions role I want to filter that table so the user who entered in NAV only can see his records....
How can I do this in the permissions?
Nav have Global Variables like USERID who returns the user?
If Nav has can i use it in security filter in permissions?

matttrax

Unfortunately you can't apply filters in Security Filters or Properties (like TableView) that aren't based on hard coded values.

On the forms, though, you can set filters. And look into FILTERGROUP so that the user can't take off the filters you've applied.

Marije_Brummel

Have you tried field level security in the SQL option? This might work for your case.

You might also want to have a look at how the standard package filters on the responsibility centers.

Kc_Nirvana

Mark Brummel wrote:

Have you tried field level security in the SQL option? This might work for your case.

You might also want to have a look at how the standard package filters on the responsibility centers.

How can I configure field level security?
Responsibilty centers?? What is this?

matttrax

Look up the help topic Responsibility Center Table in Microsoft Dynamics NAV Help from the NAV client for more information.

Kc_Nirvana

How can I configure field level security in SQL?
Can someone explain me?

David_Singleton

Kc_Nirvana wrote:

How can I configure field level security in SQL?
Can someone explain me?

Lanham (http://www.lanhamassoc.com/securitymgmt.htm) have an add on that does this. Its a fairly generic tool that can be integrated in to most versions of Navision. Its quite a job to set up in the beginning but once up and running its pretty simple to maintain.

I am not a big fan of this type of security control, but if you must have it for legal reasons then its worth looking at.

If this is just a "we would like" from the customer, then work on form security and creating different forms for different users.

Kc_Nirvana

Thanks for the answer.. But what i wanted to know if Dynamics NAV had the solution I wanted in standard.
In this case, because NAV standard doesn't meet what i want, i'm developing the type of security i want.
Thank you all for all the answers