Query regarding the user rights control on attachment

bhatia7080

Hi there..

Can anyone please let me know to how to control the user rights for attachments in Nav 5.0

Client want to define the user rights for view,edit and create attachment on orders.

Please Help

Thanks in Advance

navuser1

I Think you can do it..

Table ID is 2000000068 and Table Name is Record Link.
....
....
Do the Rest.

bhatia7080

Table 2000000068 only shows the links details but Client want to define the rights like..

user1 can attach or delete the document
user2 can only see the document but cannot delete or change the attachment

Please let me know to what should be the permission right for these individual users.

Please help

thanks

navuser1

Create Role ID ( Tools ---> Security ---> Roles ) and assign these Role ID to the concern users (User1 and User2 ).

navuser1

Study the document w1w1ism. Here you can get details information.

bhatia7080

Thanks for your response

But my problem is that when I assign permissions for attachment in native db than it works fine but my client db is on SQL and in that I am not able to restrict the attachment rights of users.

Is there any special way to restrict the users rights for attachment in SQL DB?

Please Help

Thanks

navuser1

bhatia7080 wrote:

Thanks for your response

But my problem is that when I assign permissions for attachment in native db than it works fine but my client db is on SQL and in that I am not able to restrict the attachment rights of users.

Is there any special way to restrict the users rights for attachment in SQL DB?

Please Help

Thanks

I think It's not depend on Server Option (Native/SQL). [-(