Connecting to a Database Using Connect As

From InterBase
Jump to: navigation, search


If you want to access the Connect Database dialog in IBConsole to connect to the database using a different username and password from that which was supplied in the server login, you can do so by one of the following methods:

  • Select a disconnected database in the Tree pane. Choose Database|Connect As or choose Connect As in the Work pane.
  • Right-click a disconnected database in the Tree pane and choose Connect As from the context menu. This displays the Database Connect dialog box:

DatabaseConnect.gif

To Connect to a Database:

1. Verify that the database displayed in the Database field is correct.
2. Type the username and password for the database in the corresponding User Name and Password text fields.
3. If you want to connect as a role, specify the role in the Role text field. This is optional. Connecting as a role gives you all privileges that have been assigned to that role, assuming that you have previously been granted that role with the GRANT statement. Once you have typed a character in the Role field, the Case Sensitive Role Name field becomes active. Check this box if you want the server to consider case in the role name. Role names are case insensitive by default.
For more information on roles, refer to SQL Roles.
4. Select the SQL Client dialect. The dialect for the database connection will default to the lower value of the client or server. For more information on SQL dialects, refer to “Understanding SQL Dialects” in the migration appendix of the InterBase Operations Guide.
5. Optionally, you can choose a character set to use. If you do not specify one here, the server uses the default set that was specified at creation time.
6. Click Connect.

Once you connect to a database, the database tree expands to display the database hierarchy.