Specifications

94 Using Databases with ID Works Projects
ID Works Standard and Enterprise Version 5 Administrator’s Guide
tab, Database Login area gives you have three choices for setting up
your project:
Use database login settings—ID Works users must supply a
separate database user name and password to access the
database.If you enter a user name and password in the Connection
tab of the Data Link Properties dialog box, the user name may be
displayed as a default name in the database login prompt.
Use ID Works user name and password—The ID Works
application passes your ID Works user name and password to the
database server whenever you access the database. If you choose
this option, you must assign the same user names and passwords for
ID Works access that the database administrator assigns for
database access. In addition, you should warn ID Works users not to
change their ID Works passwords. If an ID Works password were
changed and then passed to the database server, the database
security software would detect a wrong password. Depending on the
database used, the user might be asked to reenter the database
password or the user might be denied access. If you choose the Use
ID Works user name and password option, do not enter any user
name or password information in the Connection tab of the Data Link
Properties dialog box.
Use this user name and password—The ID Works application
passes the user name and password you supply for the project to the
database engine whenever you access the database. Because the
user name and password are not displayed, users cannot use them to
gain access to the database outside of an ID Works application. This
offers a higher level of security.
Using Schema/Owner Name to Identify Tables in
Production
Some databases require the owner name as part of the table or view
name to guarantee that the correct object is being referenced. For
most databases, it is possible to avoid this restriction by using public
synonyms to create an alternate name for the table.
If your database system does not support public synonyms—or if
your database administrator chooses not to use them—you should
select Use schema/owner name to identify tables in Production
on the Data Source tab. This option places the schema name in front