# Create Member Auth View

*Article Topics:* [*Setup*](https://docs.toomuchmedia.com/getting-started/common-topics/setup) 

Creating a Mysql View allows for the list of active members to be directly related to the member table rather than have this information stored in a separate table. To create a Mysql view, either have you or your host run the following query:

{% code overflow="wrap" %}

```
CREATE VIEW member_auth_view AS SELECT member.memberid,member.username,member.password,member.cryptpass,member.siteid,member.networkid,identifier.tourid,identifier.optionid,identifier.programid,member.trial,member.token FROM member LEFT JOIN identifier ON member.identid=identifier.identid WHERE status=1
```

{% endcode %}

Once the View is created, authentication of your members area would look to this new table view "member\_auth\_view" rather than looking to "member\_auth".

Please Note: Since Views do not have database keys, clients with a large amount of members should not consider using a MySQL view as this may cause performance problems on your server