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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Difference between aspnet_Users table and Users tableDifference between aspnet_Users table and Users table
Previous
 
Next
New Post
1/17/2006 11:17 PM
 

I am running a DNN 3.2.2 installation with multiple portals setup.

I've noticed that the Users table has a user (ID=2) username=admin.

However, in UserPortals, UserId 2 is mapped to several portals (which I believe may be an error).

For example:

In portal 1 the admin user corresponds to UserID 2 in the Users table.
However, I don't see an entry in the Users table for portal 2. But, if I add a documents module to a page in portal 2. Then, portal 1's admin show's up as the owner. Also, if I login in to portal 1 and update the admin's First and Last name, it is reflected in portal 2.

What's going on?

Which Users table is for what and how do I fix this?

 
New Post
1/19/2006 12:58 AM
 

Actually this is done on purpose to sort of loosely support a basic requirement of Intranets ( for SSO ).  That is, if a user registers on a different portal within the same install with the same username & password... its assumed ( with an extremely high likelihood ) that its the same user.  It essentially makes that userid a member of both portals, which is what the UserPortals table is telling you.

There is nothing to fix.  If you intend for the users to be distinct folks, use different usernames... because a requirement in DNN is unique usernames across the installation ( i.e "joe" can only exist as one user in one portal... unless he's the same guy, as above ).


Scott Willhite, Co-Founder DNN

"It is only with the heart that one can see rightly... what is essential is invisible to the eye. "
~ Antoine de Saint-Exupéry

 
New Post
1/19/2006 1:16 AM
 

Scott,

Thanks for the reply and the clarification.

The issue I have is that by default when I've created new portals, I've setup the administrator account with username admin so that each portal's administrator account has a username of "admin".

It works fine for login, changes, etc. because the passwords are different across portals. For instance, admin from Portal 1 can't login as "admin" in Portal 2. The problem is that if I am logged in as "admin" in Portal 1 and update the First Name and Last Name for the admin user account, and then go add a document to a documents modules in Portal 2. It is showing the first and last name of the admin user from Portal 1 as the owner. Yet, if I go the user account details for admin in Portal 2, it still shows the First and Last Name that was originally setup in Portal 2.

This is where there appears to be a disconnect. Can I not setup the administrator account username as "admin" for each portal? I understand that subsequent user accounts should be separate, but by default when you create a new portal in DNN, it creates the user admin with password admin. Additionally, I can't rename the administrator accounts for portals after they have been created, so how am I supposed to correct this?

Please help!

Thanks in advance,

Adam

 
New Post
1/19/2006 1:55 AM
 

Forgive me, its been a while since I looked into this...

Bottom line is that its best for them to be separate.  My personal rule is to name the admins "admin_alias".  Bulky, but I never have a collision.  Is it the new portal create that is allowing you to do this?  Or a template?  Because it sounds like a bug... it really shouldn't take if the passwords don't match.  In a pinch, you can retrieve your passwords if you have control of your DB.... copy the password ( and passwordsalt ) from the admin account in the aspnet_users table to another user and do a "forgot password" to have it emailed to you.

btw... here' some SQL to change an existing username.  But you'll have to add the new corresponding ones in the Users table.

DECLARE @OldUsername varchar(50)
 DECLARE @NewUsername varchar(50)
 SET @OldUsername='bigwebmaster'
 SET @NewUsername='DanCaron'

BEGIN TRAN
 update aspnet_users
 set UserName=@NewUsername, LoweredUsername=lower(@NewUsername)
 where lower(UserName)=lower(@OldUsername)
 IF @@ROWCOUNT=0
  PRINT 'User ' + @OldUsername + ' not found in aspnet_users table.'
 ELSE
  PRINT 'User ' + @OldUsername + ' changed to ' + @NewUsername + ' in aspnet_users table.'
 update users
 set Username=@NewUsername
 where lower(UserName)=lower(@OldUsername)
 IF @@ROWCOUNT=0
  PRINT 'User ' + @OldUsername + ' not found in users table.'
 ELSE
  PRINT 'User ' + @OldUsername + ' changed to ' + @NewUsername + ' in users table.'
 update forum_users
 set alias=@NewUsername
 where lower(alias)=lower(@OldUsername)
 IF @@ROWCOUNT=0
  PRINT 'User ' + @OldUsername + ' not found in forum_users table.'
 ELSE
  PRINT 'User ' + @OldUsername + ' changed to ' + @NewUsername + ' in forum_users table.'
If @@ERROR=0
 BEGIN
  COMMIT TRAN
  PRINT 'username change committed'
 END
ELSE
 BEGIN
  ROLLBACK TRAN
  PRINT 'username change rolled back'
 END
GO


Scott Willhite, Co-Founder DNN

"It is only with the heart that one can see rightly... what is essential is invisible to the eye. "
~ Antoine de Saint-Exupéry

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Difference between aspnet_Users table and Users tableDifference between aspnet_Users table and Users table


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