NAV Service account usage in RTC client
vivek4121
Member Posts: 165
Hi All,
Is there any where I can check where all places (setups / Job Queues/ Web services) a service account has been used in RTC client?
Thanks
Vivek
Is there any where I can check where all places (setups / Job Queues/ Web services) a service account has been used in RTC client?
Thanks
Vivek
0
Best Answer
-
Filtering the column RelationTableNo for numbers 91 or 2000000120 gives you a list of fields which have a relation defined to either table 91 User Setup, or to table 2000000120 User.
These are fields which are supposed to have only values present either in table 91 or in table 2000000120 - so the most likely places where your service account may have been used.
Slawek
Slawek Guzek - www.yitron.co.uk
Business Central, MS SQL Server, Wherescape RED;5
Answers
-
If a service account is supposed to be used anywhere it must be added as a regular user (in Users table). It often needs to be added to User Setup table as well.
If you have it in Users table then you can use Page 7702 which gives you list of all fields in all tables. Filter for RelationTableNo = 91|2000000120, that will be a good starting point to get the list of fields where your account has been used.
Nothe however that Page 7702 may not give you a complete list of fields as not all fields have defined relations, and also conditional relation won't show up in there.
Slawek
Slawek Guzek - www.yitron.co.uk
Business Central, MS SQL Server, Wherescape RED;0 -
Hi Slawek
I got your point that Page 7702 will give me list of all fields in all tables.
Could you please elaborate your point :
"Filter for RelationTableNo = 91|2000000120, that will be a good starting point to get the list of fields where your account has been used."
Thanks
Vivek0 -
Filtering the column RelationTableNo for numbers 91 or 2000000120 gives you a list of fields which have a relation defined to either table 91 User Setup, or to table 2000000120 User.
These are fields which are supposed to have only values present either in table 91 or in table 2000000120 - so the most likely places where your service account may have been used.
Slawek
Slawek Guzek - www.yitron.co.uk
Business Central, MS SQL Server, Wherescape RED;5 -
Thanks Slawek0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 611 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
