Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Tables : User , User Setup , User Personalization and Login
alok_dida
Member Posts: 73
Hi Experts,
1) Please differentiate all these User , User Setup , User Personalization and Login tables.
2)Can somebody tell me what is difference between table User and table Login?
I have seen that when I run form User Personalization and look up for User Id at that time it shows entry in Logins form whose source table is Login table. But when i am running Logins form separately it's not showing any entry.
Same thing happening with User Setup Form. When i am look up for User id in this form its opening Users form and in that i also look up for user id it will also open up Logins form.
Is that mean that for all User related things are stored in Login table ? And if yes than when its not showing any single entry when i am running from Logins separately?
3)Suppose i want to add any more field regarding any User like his birthdate than where should i add this field? In login table or User table or User Personalization or User setup?
Please give me proper details for this. I am very confused regarding this.
1) Please differentiate all these User , User Setup , User Personalization and Login tables.
2)Can somebody tell me what is difference between table User and table Login?
I have seen that when I run form User Personalization and look up for User Id at that time it shows entry in Logins form whose source table is Login table. But when i am running Logins form separately it's not showing any entry.
Same thing happening with User Setup Form. When i am look up for User id in this form its opening Users form and in that i also look up for user id it will also open up Logins form.
Is that mean that for all User related things are stored in Login table ? And if yes than when its not showing any single entry when i am running from Logins separately?
3)Suppose i want to add any more field regarding any User like his birthdate than where should i add this field? In login table or User table or User Personalization or User setup?
Please give me proper details for this. I am very confused regarding this.
0
Comments
Ans:1
User Table, used to store the password and userid and name at the time when you create the User..!!!
User Setup, used to provide the permission for allowing posting (from-to posting dates). Even there are few other fields also there, you can have idea by their captions also...!!
User Personalization and Login I dont know that much...
Ans:3,
I have never added any field into User Table, regarding its, personal details and I dont know whether any other table exists for that or not..!!! But might be the User table is okay other than the tables you have mentioned to add custom fields.
Kashyap
Hi Kashyap,
Thanks for your reply.
For Ans 3..Me decided to add that field in User table . Because I have found many fields which is regarding to User like email and other fields. In User table they are just storing Username and Password so better to store it in a User Setup table instead of User table.
still my 2 other questions are unanswered.
Logins are used to store informaton about a login such as name and email for both windows and database login.