Bastionhost uses single sign-on (SSO) authentication to connect your local database client directly to an authorized database — no manual credential entry required. In this topic, you will:
Configure a local database client as your O&M device.
Connect to a database using either the Bastionhost console or the O&M portal.
Prerequisites
Before you begin, ensure that you have:
Database O&M permissions granted by an administrator. For setup instructions, see Use the database management feature and Authorize users or user groups to manage assets and asset accounts
A local client that supports Bastionhost Assistant installed on your system. See Clients supported by Bastionhost Assistant
Bastionhost Assistant installed on the same system as your local client. See Download and install Bastionhost Assistant
Step 1 of 2: Configure an O&M device
Tell Bastionhost which local client to launch when you initiate a database connection.
Log on to the Bastionhost console and select the target region in the top navigation bar.
In the Bastionhost list, find the target instance and click Manage.
In the left navigation pane, choose Asset O&M > Host O&M.
On the Database O&M page, click Device Settings.
In the Device Settings panel, click the tab for the database type you want.
Configure the following settings:
Setting Description Session title Name for the O&M session. Windows only. Local client The database client to launch. Full path Full path to the client. macOS only.
Step 2 of 2: Connect to a database
Choose the method that matches your account type.
Bastionhost console (for RAM users)
Log on to the Bastionhost console and select the target region in the top navigation bar.
In the Bastionhost list, find the target instance and click Manage.
In the left navigation pane, choose Asset O&M > Database O&M.
On the Database O&M page, find the database you want.
In the Remote Connection column, click the drop-down arrow. In the dialog box, select a database account, set Logon Method to Local Client Logon, and click Log On.
O&M portal (for non-RAM users)
Log on to the O&M portal. For instructions, see Log on to the O&M portal.
In the left navigation bar, click Database.
In the Remote Connection column, click the drop-down arrow. In the dialog box, select a database account, set Logon Method to Local Client Logon, and click Log On.