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.