Schema tab
On the Schema tab, you select the database and specify the log-on data of the schema user:
- Authentication: Select the authentication method that you use for the schema user from the drop-down list. You can select Basic or Windows authentication.
- User name: If Basic authentication is selected, specify the name and password of the schema user. If Windows authentication is selected, you do not have to specify a user name and password. The log-in data of the current user is used.
- Password: Specify the password of the schema user.
- Select database: Select the database for which you create a connection from the drop-down list.
Note: To connect to the repository and to work with it, you must map the SQL Server database
to the repository by using the required user login. The default schema for the mapping
of the SQL Server database is dbo. To allow the required operations on the repository,
these roles of the mapped SQL Server database must be enabled:
- db_datareader enables reading data from the database
- db_datawriter enables writing data into the database
- db_ddladmin is required when you create a repository or when you enable another database interface.
- db_securityadmin is required when you create a repository or when you enable another database interface.
- To create or delete an existing repository, enable the SQL Server role dbcreator. This role is not required if you only work with an existing repository. Other roles are not required.