By Lee Sykes
May 2008
In this tutorial we demonstrate using SQL queries for working with DotNetNuke security roles and users.
Using SQL queries can help you to easily maintain and manipulate the registered user and security role data in your DotNetNuke portal.
We demonstrate how to export users who are in a certain security role, how to copy registered users to Excel, and we also demonstrate how to remove users from a security role based on their email address.
These SQL query methods are ideal for managing users of your DotNetNuke portal for email newsletters, paid subscriptions, etc. any tasks where you can work with the data of users and security roles is ideal for SQL queries and this tutorial provides you with all the information you need to get started, even if you do not have any experience of SQL.
If you do not have any experience of SQL, we demonstrate how you can use the built in Query Editor in SQL Server Express to build your own SQL queries.
The videos contain:
Video 1 - Introduction to SQL queries and How to Use The Query Editor
- Introduction
- Recap of introduction to SQL queries tutorial
- How to view the security roles table
- How to write a query to find users in specific roles
- How to use the Query Editor
Time length: 9min 8secs
Video 2 - Exporting Users and Removing Security Roles using SQL
- How to copy query results (registered users) into an Excel worksheet
- How to make a query faster
- How to remove a group of users from a security role based on their email address
- How to convert a ‘SELECT’ query into a ‘DELETE’ query
- How to clean up a SQL query using the ‘IN’ statement
Time length: 7min 10secs
Total time: 16min 18secs