View permissions

thomlin
thomlin Member Posts: 2
edited 2011-08-18 in SQL General
Hi!

Does anyone have a "permission-guide" to what kind of permission I need to set on a user in Nav2009 Classic and SQL 2008 when the user needs to open a linked table in Nav which points to a view in the Nav database which gets it's data from to another table in another database on the same server?
At the moment it seems that I need to set select permission on the table in the other database which is fine but also DB owner on the Nav database which I don't want to do....running standard security...I must be missing something...
Thomas

Comments

  • bbrown
    bbrown Member Posts: 3,268
    Grant the NAV database's PUBLIC role "SELECT" permissions on the view. The give the user NAV rights to the NAV table object.
    There are no bugs - only undocumented features.
  • stryk
    stryk Member Posts: 645
    thomlin wrote:
    Hi!
    Does anyone have a "permission-guide" to what kind of permission I need to set on a user...
    You'll find this information in the NAV documenation, e.g. "Installation & System Management (SQL)" (w1w1isql.pdf) which is probably on your NAV DVD.
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool

Categories