In many database environments, a database administrator defines the access privileges for users accessing the database, usually through username and password. When a person attempts to connect to a database, the database ensures that the username and password are valid and then imposes access requirements on the user.
Privileges can restrict user access so that a user can do the following:
In ColdFusion MX, you use the ColdFusion MX Administrator to define database connections, called data sources. As part of defining these connections, you specify the username and password used by ColdFusion to connect to the database. The database can then control access based on this username and password.
For more information on creating a data source, see Configuring and Administering ColdFusion MX.