# AD / Database Hybrid

**URL:** <https://forum.inductiveautomation.com/t/ad-database-hybrid/10167>\
**Category:** Ignition\
**Created:** [June 24, 2015, 11:43am UTC](https://forum.inductiveautomation.com/t/ad-database-hybrid/10167 "2015-06-24T11:43:18Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![angelo.bersani](https://avatars.discourse-cdn.com/v4/letter/a/ec9cab/32.png) [@angelo.bersani](https://forum.inductiveautomation.com/u/angelo.bersani)\
**Post date:** [June 24, 2015, 11:43am UTC](https://forum.inductiveautomation.com/t/ad-database-hybrid/10167/1 "2015-06-24T11:43:18Z")

</div>

Hi,

I created a user type source AD / Database Hybrid in Ignition.  
I created a new project and I set as the type of authentication that I created earlier.  
I created a database in SQL Server and I have created three tables: user\_table (username, firstname, lastname, schedule, language notes), roles (rolename), user\_role\_mapping (rolename, username). I added a user with Manager role and the list of users and roles of ignition see you that I put in the database.

If, in ignition, I go in project / properties then project / general, I have the possibility to set required clients roles but I’m forced to make, in addition to the roles I want, the role Administrator. I have 2 questions:

1. Why in this proprerties i must set Administrator role, if i don’t have this role in the db?
2. Admitted that put the role administrator, I no access the project. Why? I did the same steps with a user source AD / Internal Hybrid and in that case it works.

thanks,  
best regards