Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

View and User-Rights (Application Role) Expand / Collapse
Author
Message
Posted Tuesday, July 02, 2013 3:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 02, 2013 3:02 AM
Points: 1, Visits: 36
Hi,

sorry to dredge this old post up but it is exactly the same problem that I am facing.

I have given the guest account (on both databases DB_A & DB_B) connect permissions but still get an access denied error message in Navision Nav.

We are trying to do the exact same thing as the OP (view in DB_A which looks at a table in DB_B)..

the only difference is that this is in the SQL 2005 forum and we are actually using 2008 R2 so wondered if there are some specific differences with regards to the guest account between the two versions.

Thanks
Chris
Post #1469356
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse