Connect to database with different credential for different user?

Hi,
  First I'm beginner for CodeIgniter. Iam trying codeigniter for a new project.


In my site, there are three level of user.  Each user level have access to the certain tables in the database. If I use CodeIgniter for my project, How to connect with different Database credential when a user logged in?

If i would be in a similar situation i would use the default db connection for administrative tasks (get global settings, user profile).

Then i would use a the user specific db connection to access other functions. Check the "Connecting to Multiple Databases" and "Manually Connecting to a Database" section in the guide.