As noted previously, you should follow the security guidelines that your ODBC data source has established for your applications. Some ODBC data sources require that all users supply a valid login name and password to access them. In addition, ODBC data sources often provide security that controls access to data sources and objects within data sources. Data-source access security typically has four levels: system administrator, database owner, database object owner, and public:
System administrators can grant or revoke permissions to other users to create or own a wide type of objects; for example, databases.
Database owners can grant other users permission to access or modify a database or its objects.
Database object owners can be the owner of objects in a database owned by another user.
Public database objects can be accessed by any users without restriction.
For more information on database security, see the documentation for your data source.
Note: There are specific security requirements for accessing data with the DataServer that relate to creating a schema holder. For details, see Creating a schema holder.
System administrators can grant or revoke permissions to other users to create or own a wide type of objects; for example, databases.