Permission to modify a single field by a single user

andy76

Hello,

we need that a single field a table is editable by an only one user in the form of Items. Is that possible setting permission standard?
Or is it necessary to write code to manage that?

Thank you very much

Savatage

Probably depends on how broad you will take this. Is it really 1 field out of the whole database. Or is it 1 field "For now"?

How about a boolean in user table. ex/"Std Cost Modify Permission"

in the item table when that field is modified you can check the user table to see if they are allowed to modify that field else throw an ERROR.

andy76

Is there a table in Navision with the list of all tables?
I am creating a new user table with a field called TableName that I would like to do a TableRelation to the list of all tables?

Thank you

mohana_cse06

Did you check Object,AllObj or AllObjwithcaption tables?

David_Singleton

Andy if this is something you need in many places then take a look at Lanhams field level security.

andy76

Where can I find that ' Lanhams field level security'?
Is that free?

Thank you

ara3n

It's not free and you can find the info here.

http://www.lanhamassoc.com/security-management.htm


I would not implement it this. It touches every form

David_Singleton

ara3n wrote:

It's not free and you can find the info here.

http://www.lanhamassoc.com/security-management.htm


I would not implement it this. It touches every form

I agree with you on this. I think of Field level security as a "last resort" but there are a few rare cases where it is the only option.

andy76

For now it is only 1 field, i would implement it.

But which is the key of table (system table??) AllObj ?

I have some problem inserting new data in new table just created.

Thank you

David_Singleton

andy76 wrote:

For now it is only 1 field,

Then Rashed is right, Field Level Security is not for you.

andy76

But is there a table where are listed all fields of each table?
In AllObj I don't see them....

Thank you very much

mohana_cse06

andy76 wrote:

But is there a table where are listed all fields of each table?
In AllObj I don't see them....

Thank you very much

Use field table for all fields..

Your previous question was for all tables..

andy76 wrote:

Is there a table in Navision with the list of all tables?

Savatage

This post seems to be about 3 different things now.

1 was allowing 1 person to modify 1 field.
2 was a new user table & relations
3 is now about trouble inserting data into a table
:-k

Virtual Tables
http://msdn.microsoft.com/en-us/library/dd338858.aspx
System Tables
http://msdn.microsoft.com/en-us/library/dd355358.aspx

I think it was confusing to him which post was answering which question.

andy76

I solved some previous problems but my last one is:

if I create a new table with a new only one field table relation "Field.No." , opening the table, and clicking the up arrow, the list of fields is not opened.
Why that?

Thank you

ara3n

because there is no lookup form for the virtual table. You have to add your code on lookujp.

You can take a look at Migration Overview form.

andy76

I opened the Migration Overview form but there is not the list o fields of a table.
What should I have a look?

Thank you

andy76

Probably you mean to have a look to trigger ShowMigrationFields under button Migration - Migration fields?

Thank you

ara3n

yes. That's what i meant.