DotNetNuke - Useful SQL Server Queries


========================
Stored Procedures
========================

exec aspnet_UsersInRoles_AddUsersToRoles 'DotNetNuke', 'pclady', 'Administrators', null
exec aspnet_Membership_GetAllUsers 'DotNetNuke', 1, 2
exec aspnet_Roles_GetAllRoles 'DotNetNuke'
exec aspnet_UsersInRoles_GetRolesForUser 'DotNetNuke', 'pclady'
exec GetRoles
exec aspnet_Membership_GetUserByName 'DotNetNuke', 'pclady', null
exec aspnet_UsersInRoles_FindUsersInRole
exec aspnet_UsersInRoles_FindUsersInRole 'DotNetNuke', 'Administrators', 'pclady'
exec GetUser 0, 3
exec GetUserRoles 0, 3
exec aspnet_UsersInRoles_GetUsersInRoles 'DotNetNuke', 'Administrators'

========================
SQL Statements
========================
select * from aspnet_Users

select * from aspnet_Membership

UPDATE Users
SET UpdatePassword = true
where userid = 2


 

What did you think of this article?




Trackbacks
  • No trackbacks exist for this post.
Comments
  • No comments exist for this post.
Leave a comment

Submitted comments are subject to moderation before being displayed.

 Name (required)

 Email (will not be published) (required)

Your comment is 0 characters limited to 3000 characters.