[firebird-support] Roles and connection pooling

[Nols Smit]

Hi,

I'm using FB 2.5 Super Server, Delphi7, UniDac database drivers and the 
IntraWeb/TMSIntraweb components.

With connection pooling, one's application (a web application in my case) 
typically open a pool of connections to the database.  A thread then use a 
connection from the available pool of connections, locks it, execute some SQL 
operations and unlock the connection.

My typical code of establishing a connection is:

procedure TDataModule1.OpenDatabase;
begin
  if IsLibrary then
    DBServer := '127.0.0.1'
  else
    DBServer := 'LocalHost';

  try
    with UniConnection1 do
    begin
      Disconnect;
      ProviderName := 'InterBase';
      Server       := DBServer;
      loginPrompt  := false;
      Database     := DBName;
      Username     := DBUser;
      Password     := DBPassword;
      SpecificOptions.Values['role'] := DBRole;

      try
        Connected := true;
      except
        raise Exception.Create('Can''t logon with supplied User ID, Role and 
Password');
      end;
    end;
  except
    raise;
  end;
end;


The question is:  If a user log in by using some (restricted) role, will this 
pooled connection still be able to serve users in other (less restricted) roles?



Regards,

Nols Smit


[Non-text portions of this message have been removed]