Got most of it... One thing I'm unsure of:
I've got most of it minus 1 thing regarding the server authentication...
1. Created table in database with a column entitled "Role" as an interger. From this I'll give each user a role that will post in to the column (i.e. "Admin" = 1, "Power User" = 2 and so on...)
When I go to Authenticate User server behavior wizard, instead of steps, I have tabs.
General, Database, and Session Values.
Here's where I get confused and need additional clarification:
In order to select the "Role" column as a session value on the Session Values tab, I must first select the Connection (got this), Table (got this) and user column (Which this would be the "Role" column) in the Database tab. But in order to complete this wizard, on the user column in the Database tab (Again I selected the "Role" column) it requires a value.
What would the value be if I'm trying to retrieve a session variable based on the Role column being an interger for each role (1,2,3)?
I included attachments of exactly what I'm looking at.
Thanks again for the help.