Defining database users

Until version 11.70.xC2, Informix® database users must be created at the operating system level and be members of the 'informix' group. Starting with 11.70.xC2, Informix supports database-only users with the CREATE USER instruction, as most other db servers. Any database user must have sufficient privileges to connect and use resources of the database; user rights are defined with the GRANT command.

Before a user can access an SQL SERVER database, the system administrator (SA) must add the user's login to the SQL SERVER Login list and add a user name for that database. The user name is a name that is assigned to a login ID for the purpose of allowing that user to access a specified database. Database users are members of a user group; the default group is 'public'.

Microsoft™ SQL SERVER offers two authentication modes: The SQL SERVER authentication mode, which requires a login name and a password, and the Windows NT™ authentication mode, which uses the security mechanisms within Windows NT when validating login connections. With this mode, user do not have to enter a login ID and password - their login information is taken directly from the network connection.

Solution

Both SQL SERVER and Windows NT authentication methods can be used to allow BDL program users to connect to Microsoft SQL SERVER and access a specific database.

See SQL SERVER documentation for more details on database logins and users.