Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Uniquely identifying usersUniquely identifying users
Previous
 
Next
New Post
9/18/2009 12:37 PM
 

Hi,

I'm developing a module in which I have a table where I store the UserID besides a value e.g.

UserID Field1
1 aaa
1 bbb
2 ccc
4 ddd

In my module I retrieve values from the table using the UserID  e.g.

SELECT * FROM MyTable WHERE UserID = 1

Essentially I want to retrieve the same values irrespective of what instance of the module I'm using in a portal.

During testing I created two Portals called PortalA and PortalB and I created a user in each with the same registration details (i.e. the same username, firstname...email address etc.).

When I created an instance of my module in PortalA and PortalB and logged in using the credentials of this new user I was suprised to see that I saw the same values in both portals. For example, If I logged in to PortalA and added an entry I'd also see it when I logged into PortalB.

Furthermore, if I changed the name of the user in one portal it is reflected in the other.

I thought each portal and its users were independent of one another?

In DNN what is user uniqueness based on?

Is the UserID field the correct way to uniquely identify a user within a portal?

Thanks,

Norman

 
New Post
9/18/2009 4:41 PM
 

Norman,
UserID as the unique id is entirely appropriate. Alrthough I know of some who use the username instead of userid for some reason when creating user-specific files or file directories, which doesn't seem right to me - too many oddball characters in a username.

Regardless, the only time that portals share a user account is when a user registers with the exact same usrname/password. Otherwise, accounts are distinct. I kind of like that feature because a single admin login can be used on a multi-portal installation to work with a bunch of individual sites.

Of course, unless someone registers with the same username/password on an additonal portal they are prevented from doing so because the system indicates that the username is already taken when they try and do so and there ia a password mismatch.


Eric Swanzey
www.swanzey.com
 
New Post
9/21/2009 4:42 AM
 

Thanks Eric,

I just have to remember that when developing my module.

 
New Post
9/21/2009 9:45 AM
 

Offhand, I don't remember seeing any module that accounts for such a circumstance - a user that might have the same account across multiple portals? But then again, it IS Monday morning :-(.


Eric Swanzey
www.swanzey.com
 
New Post
9/21/2009 8:29 PM
 

You will need to inlcude PortlId in your queries as User records are shared across portals if they use the same username and password to register.  There is a UserPortals table you should take a look at.


Philip Beadle - Employee
 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Uniquely identifying usersUniquely identifying users


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out