# Navision SQL View Permissions **URL:** \ **Category:** Developers Forum\ **Created:** [March 18, 2005, 11:40am UTC](https://www.dynamicsuser.net/t/navision-sql-view-permissions/9801 "2005-03-18T11:40:23Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![David\_Cubitt](https://avatars.discourse-cdn.com/v4/letter/d/eb8c5e/32.png) [@David\_Cubitt](https://www.dynamicsuser.net/u/David_Cubitt)\ **Post date:** [March 18, 2005, 11:40am UTC](https://www.dynamicsuser.net/t/navision-sql-view-permissions/9801/1 "2005-03-18T11:40:23Z")
Our solution provider implemented links to an external database with a view to a linked object. This works really well until I have to let some users loose on the data at which point I get an error message saying: 916,“08004” [ODBC Sql server Driver][Sql server]server user blah is not a valid user in [the other database]. Fine I thought, I’ll give them permission on the tables in the other database directly. However, I’ve given the users all permissions in the tables in the remote database, and also directly on the views in the navision database. I can see it, but I’m an administrator & presumably using builtin\admin. Giving them super in permissions also does not work (luckliy). I can’t immediately see where I’m going wrong. Any ideas? ---
**Author:** ![DenSter](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/denster/32/7478_2.png) [@DenSter](https://www.dynamicsuser.net/u/DenSter)\ **Post date:** [March 18, 2005, 1:17pm UTC](https://www.dynamicsuser.net/t/navision-sql-view-permissions/9801/2 "2005-03-18T13:17:08Z")
Those users must have access to the other SQL database, so you need to modify the SQL user, not just in Navision. Just doubleclick the user in Enterprise Manager and add the other database to their profile, you may have to add db\_owner. That worked for me. ---
**Author:** ![David\_Cubitt](https://avatars.discourse-cdn.com/v4/letter/d/eb8c5e/32.png) [@David\_Cubitt](https://www.dynamicsuser.net/u/David_Cubitt)\ **Post date:** [March 21, 2005, 3:17pm UTC](https://www.dynamicsuser.net/t/navision-sql-view-permissions/9801/3 "2005-03-21T15:17:08Z")
I gave the user concerned all the rights I could think of but to no avail. I can use MS Query via excel & get the data, but not from the Navision form. I’m still mystified. Perhaps it’s a read permission overriding the read write permission required in the chain of ownership. I’ll keep this post, er posted… ---
**Author:** ![JSoage](https://avatars.discourse-cdn.com/v4/letter/j/67e7ee/32.png) [@JSoage](https://www.dynamicsuser.net/u/JSoage)\ **Post date:** [March 21, 2005, 5:16pm UTC](https://www.dynamicsuser.net/t/navision-sql-view-permissions/9801/4 "2005-03-21T17:16:47Z")
If it is not a confidential information, you can give read permissions to guest user on both databases on tables/views you want or make it a member of db\_datareader group.