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
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-035
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
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-030 -
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
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-035 -
Thanks Slawek0
Categories
- All Categories
- 73 General
- 73 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
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 328 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
