The Database Authorization dialog box opens on connecting to a database:
On opening repository objects if automatic connection is not set up in connection settings.
If errors are encountered during connection.
If the current user does not have permissions for the requested operation.
On creating new relational objects (tables, queries, and so on) or on changing access permissions to existing objects under the user who is not an owner of the ADMIN schema.
NOTE. The Database Authorization dialog box is supported in the web application only when working with tables, external tables, and views. To open other relational objects in the web application, set up automatic connection to database, otherwise the database opening error message is displayed.
Database connection is established when the user executes the following operations: creates, deletes or edits object structure, distributes object access permissions, creates or updates users, and so on.
In the desktop application, at the top of the dialog box, there is information about the database or the user whose credentials can be used to connect to this database. The displayed information depends on where authorization has been opened from.
Set the parameters:
Use Login Credentials. Select the radio button for authorization in a database using the credentials specified in the login dialog box during logging in to the system.
Use Current Domain User Credentials. Select the radio button for authorization in a database using domain user credentials.
NOTE. If the schema uses domain authorization this radio button will be absent.
Use Other User Credentials. Select the radio button for authorization in a database using the specified parameters:
User Name. Enter name of the user who has permissions of the ADMIN schema owner.
Password. Enter password of the user who has permissions of the ADMIN schema owner.
Remember Password. If required, select the checkbox to save password. Saving password enables the user to avoid reopening this dialog box in the current connection on repeated authorization to this database.
If the user name or password is incorrect, the Database Authorization dialog box opens again.
The Connection Parameters box displays parameters of the schema of the database (server, database name).
See also: