View permissions

thomlin

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...

bbrown

Grant the NAV database's PUBLIC role "SELECT" permissions on the view. The give the user NAV rights to the NAV table object.

stryk

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.