-1

Is there a report in NAV 2009 that will show users and their roles? Does anyone know what tables in the SQL database they might be in?

Vadim Kotov
  • 8,084
  • 8
  • 48
  • 62
Jeff
  • 329
  • 3
  • 13

1 Answers1

0

You can create a report for that.

In NAV 2009 in table 2000000053 (Windows Access Control) you can check that info. Here you have Role ID and Login ID this table is for Windwos logins, for DataBase Login you can check the table 2000000003 (Member Of) here you have User ID and Role ID fields.

Jonathan Bravetti
  • 2,228
  • 2
  • 15
  • 29