Query Table Permission

nav_126
nav_126 Member Posts: 77
edited 2009-06-03 in NAV/Navision Classic Client
Dear All,

I have a very complex doubt about table permission. I want to restrict the read permission of a table from the users and even from a user who has rights to control Permission.

Is there any way to hide a single table which client has persmission according to licence but they may not be able to see using object designer?

its a typical requirement but can we control it through code?

Thnx
Navision Developer

](*,)

Comments

  • bylle
    bylle Member Posts: 47
    Hi!

    This is not possible the "legal" way - all objects, except special Navision Tables, are always shown in the Object Designer even though the object is not in the license.

    You can hide the table with doing some fixes the Sql way. Objects shown in the Object Designer is just a record in a table, and if you delete this record, the Table will be invisible for everyone, but can still be used from Forms, Reports etc. I will though not recommend this - because you will not be able to make any changes to the Table source code afterwards from Navision, also you will not able to see the Table in any lookups.

    What is the purpose with this table? If it is to collect "hidden" data, then why not create a pure Sql table, and then use ex. ADO to fill it.

    If it is just to prevent the users from executing the table from the object designer - then you can prevent this with the help of user rights. Just give the users indirect Execution Permissions. In this way, the users will be able to use the table in forms, reports etc. - but will not be able to run the table directly from the Object Designer.
    Ingrid Byllemos
    My techblog
    Meet me @ LinkedIn
  • David_Singleton
    David_Singleton Member Posts: 5,479
    nav_126 wrote:
    Dear All,

    I have a very complex doubt about table permission. I want to restrict the read permission of a table from the users and even from a user who has rights to control Permission.

    Is there any way to hide a single table which client has persmission according to licence but they may not be able to see using object designer?

    its a typical requirement but can we control it through code?

    Thnx
    Navision Developer

    ](*,)

    Is this a payroll type issue?
    David Singleton
  • nav_126
    nav_126 Member Posts: 77
    Ya David,

    You got it right, its related to payroll, my client wants to hide salary details of all employees from administrator also.

    the administrator of his company has super rights to handle some navision queries and issuing rights to other users so how can i protect it to run.?

    do navision have anything that can stop a table to be run?



    thanx
  • nav_126
    nav_126 Member Posts: 77
    Please reply....

    If anyone can suggest another solution... its urgent ....


    ](*,)


    Regards

Categories