User`s guide

288 Guardall Director V4.74 User's Guide 21-0381E v4.7.4
When you click [Change...] for each
item below, you will be asked to enter
a "User Login" and password. For a
typical system (i.e., not being
managed under SQL server), you can
leave the login names at our default
settings, and enter only your desired
passwords.
Tip: For a system managed under SQL
server, this information must be set to
match the 'User Logins' (and passwords)
for the Director database as entered at the
SQL Server PC.
Notice
: If you wish to change these
settings later on, you must ensure that no
one is presently accessing the Director
database (see the steps under "Table
Repair Utility", previous/above).
- Query User / Change Query User
Login: This allows you (or your
custom software) to link to the
database and view stored information. This
allows setting up custom queries (reports), and
is also used by the auto-user import feature
(ERM integration).
Server roles: None required.
- Import User / Change Import User Login: This
is used with the automated user import feature
(ERM integration) feature.
This is required when opening and editing the tables:
ErmUserImport and ErmUserImportResult;
Server roles
: None required.
- Backup User / Change Backup User Login:
This allows the Guardall Director software to
backup and restore its database (for a system
managed under SQL server);
Server roles: Disk Admin.; Database Creator.
- System Administrator / Change SA User
Login: This allows the Guardall Director
software to access the database (for a system
managed under SQL server).
Server roles: System Administrator.
Linking to the Database (Used for:
Custom Query/Reporting; ERM
Integration)
Introduction
Director's "Database Query" feature allows you
(or your custom software) to link to the
database, and view or use the data as desired.
(This pertains to read-only database 'views'
(provided) that mirror the contents of the
database.) This allows setting up custom
reports (e.g., setting up your own custom
queries in MS Access, or using a program
such as "Crystal Reports". Database 'views'
are also used with the auto user-import feature
(ERM integration).
Notice: To generate custom queries and reports, you
need to create a new (blank) database, and link to
the Director database as discussed below.
Typical Systems (i.e., not running SQL
Server)
"Query User Login" information is required to
allow linking to the database. For a system set
Guardall Director-Repair.exe User Logins 