Accessing into SQL server without db_owner

Comments

• Options

  bbrown Member Posts: 3,268

  2014-11-17

  You don't say which version or how these users are trying to access NAV.
  
  Regular users should NEVER be DB_Owner. Only users doing development (which should not be done in live) or maintenance task such as object imports need to be DB_Owner or higher.
  
  With NAV 2009 (or below) regular users should only be members of the database's Public role. Which is assigned by default. With NAV 2013 (and above) regular users don't even need to exist in NAV.

  There are no bugs - only undocumented features.

  0
• Options

  darmaa Member Posts: 65

  2014-11-17

  Version is NAV 2009 R2 and users trying to access by Windows authentication. Default is 'Public'. So how can I solve it?

  0
• Options

  bbrown Member Posts: 3,268

  2014-11-17

  Which client are they using, and what are you trying to solve? I'm unclear of the exact problem you are having. Regardless of your problem, assigning SQL permissions beyond Public is not the solution.

  There are no bugs - only undocumented features.

  0
• Options

  darmaa Member Posts: 65

  2014-11-17

  cannot access into database by Classic Client. it appears "Invalid User name and password" error message. How can I access into database without db_owner permission?

  0
• Options

  bbrown Member Posts: 3,268

  2014-11-17

  It would appear you do not have your users setup in the database correctly. You should review the process and set them up again. It's difficult to troubleshoot this problem thru a forum. I'd suggest you reach out to your NAV partner or consultant for assistance here. DB_Owner is not the solution to this problem.

  There are no bugs - only undocumented features.

  0
• Options

  darmaa Member Posts: 65

  2014-11-17

  Thanks bbrown,
  I`ll try it.

  0