1. The Salmon Users Kit for Personal Starter Sites

Salmon Training has created a set of database programs (known as "stored procedures") that simplify the process of approving users and adding them to the Administrators and Friends roles. Once they're installed on the live database then approving "joebloggs" is as simple as running this SQL statement via a Query Editor on your web site:

exec salmon_Approve 'joebloggs'

And making "joebloggs" an administrator is as simple as running this statement:

exec salmon_MakeAdministrator 'joebloggs'

While approving "marysmith" and adding her to the Friends role is as simple as running these two statements:

exec salmon_Approve 'marysmith'

exec salmon_MakeFriend 'marysmith'

2. Install the Users Kit on your Live Database

The installation routine is very simple. Here's a step-by-step walkthrough.

1. Download the zip file containing our SQL script by clicking on the link below.

    Click Here to Download the Zip File

2. Unzip the file called salmon-add.sql and save it in the /app_data folder of your Personal Web Site on your PC or laptop.

3. Log into your host site's database Control Panel and run the SQL script against your database.

For example, on Go Daddy you open the the SQL Server Database Manager, open the Query Analyser, click the "Submit SQL Script" button and submit the downloaded file (don't forget to click the "submit" button). If you're not sure about these steps - our Go Daddy Personal Starter Kit Training Pack has a video showing the process.

3. Approving Users and Assigning Administrators

Now that you've installed the Salmon Users Kit, you can use it to approve the first user account registered on the website and then assign that user account to the Administrators role. You just need to know the User Name you are dealing with.

In our examples here, the user name is "mcobrien".

On your host site's Database Query Editor (e.g. Query Analyser in Go Daddy), submit this statement:

exec salmon_Approve 'mcobrien'

You have just enabled the 'salmon' user account to log into the web site by approving the user. You also want to have an administrator account that can manage the photo albums.

Submit this statement:

exec salmon_MakeAdministrator 'mcobrien'

And that's it! You now have an administrator.

4. Approving Users and Assigning Friends

Our friends are starting to create accounts on our web site, and we want to approve their membership and give them access to the private areas of the site.

Let's take Joe Bloggs as an example. Joe has created an account with the user name of 'joebloggs'.

Type this statement into your live Database Query Editor and click the submit button:

exec salmon_Approve 'joebloggs'

You have just enabled the Joe's user account to log into the web site by approving the user. Now you want to give him access to the privileged parts of the website.

Do so by submitting this statement:

exec salmon_MakeFriend 'joebloggs'

5. Personal Starter Kits on Go Daddy

Salmon Training has put together an extensive training pack that walks you step-by-step through creating a Personal Starter Kit web site on your local PC to putting it live on your Go Daddy shared hosting site. The training pack includes tutorials, screenshot walk-throughs, and five videos that follow the deployment a real web site.

A major part of the training focuses on databases, users and roles. The security database within the Starter Kit is what most developers have trouble with when rolling out to the live host. Follow our step-by-step training to replace frustration with the enjoyment of succesful rollout.

Click here to get full details on our Go Daddy Personal Starter Kit Training Pack.