Posted by daneelcm on May 29, 2012 at 3:45pm
Hi everybody:
Is there a possibility to connect to MSSQL with trusted connection associated with drupal users; maybe using LDAP or something like that?
Otherwise can be set a pool of connections for the drupal users and keep track of who user use some login?
Please light me on this.
PD: I do my best with the English so if there errors sorry for that.
Comments
It is possible to connect
It is possible to connect Drupal with a LDAP server for authentification. Is that what you mean?
Yes, but i want to know if
Yes, but i want to know if once connected with LDAP servers (using the LDAP module) the drupal users go to connect to MSSQL thru the domain user using trusted connection
Possible but difficult
What you are describing is possible but it's not trivial to setup.
I'm assuming that this is for some custom queries to an existing app that you are integrating into Drupal ... (if this is for Drupal customization there's probably a much simpler way to do it).
(1) Assuming the Drupal Server and the SQL Server are on the same domain you can use Kerberose to do the authentication (http://drupal.org/project/kerberos_authentication) rather then LDAP ... then use Kerberose delegation: http://www.easysoft.com/products/data_access/odbc-sql-server-driver/kerb...
(2) another option would be to use the MS SQL server "Execute AS" functionality: http://www.databasejournal.com/features/mssql/article.php/3596701/SQL-Se...
but to be honest I can't imagine that there isn't an easier way to control the permissions on your MSSQL server then per user.
Interesting… it’s really a
Interesting… it’s really a hard job!!! Thanks for your answers.
What did you recommend me for this scenario:
• One Drupal installation.
• Many DB’s with the same structure but different info.
The idea is set permission to users to access to the info of those different databases. Once a user is logged in he can ask for info of some of the DB’s he has access.
I guess this is pretty specific but getting the idea of this use case what combination of modules can I use?
Here are some features I’ll be seeing to find out if can help me…
• Target’s Databases. (it’s there some module working with this feature???)
• Multisite.
Hope don't bother to much!!! Sorry.
Several Ways to do it ..
Based on "One Drupal installation." & "Many DB’s with the same structure but different info."
This isn't really a MSSQL issue ... the solutions you should be looking at are database independent (on Drupal 7).
Does your content actually need to be in different databases or do you just need to segregate content and give different different access base on users/groups/roles-whatever?
Here are some of the areas you should look (from easiest to hardest to setup):
(1) Taxonomy Access control.
Will let you set up access based on a taxonomy hierarchy and then grant different roles different access ... simple but super powerful.
http://drupal.org/project/taxonomy_access
(2) Organic Groups
Set up "Groups" and then associate content with groups. Can also add the "Spaces" module if you need more control over what different groups see. There are several modules in the OG suite giving different access levels. (see Drupal Commons and Open Attrium for examples of how this is done).
http://drupal.org/project/og
http://drupal.org/project/spaces
(3) Bakery SSO module + Multi-site code base
Bakery lets you sync and single sign-on users across an number of sites. You can use Drupal's built in multi-site functionality so you'll only need to maintain one code base. You'll probably also need features to keep the various sites in sync.
This is closet to what you describe above, but you'll probably be better off with a simpler solution if you're new to drupal.
http://drupal.org/project/bakery
http://drupal.org/project/features
http://drupal.org/node/43816
Good Luck!
d.
Ok, thanks a lot friends.
Ok, thanks a lot friends.