HP Web Jetadmin Software Bedienungsanleitung PDF herunterladen (Seite 19)

Therefore, the following minimal rights must be assigned:

 db_datareader - Granted: SELECT

 db_datawriter - Granted: DELETE, INSERT, UPDATE

 db_ddladmin - Granted: ALTER, CREATE TABLE

 EXECUTE

Although EXECUTE is not a built-in role, several techniques can be used to assign EXECUTE rights to

the HP Web Jetadmin user. A simple script can be run to assign EXECUTE to the user or a new role

can be created that applies EXECUTE rights on the database schemas. For more information about

applying EXECUTE rights, see the SQL documentation. EXECUTE is required for the Stored Procedures

that HP Web Jetadmin runs, especially in the areas of adding and deleting devices. Discoveries can

fail without the ability to run these stored procedures.

The db_ddladmin role runs any Data Definition Language (DDL) command in a database. HP Web

Jetadmin can use this role for the following:

 The CREATE, DROP, and ALTER commands are required when HP Web Jetadmin is upgraded to

a new version or a new Feature Pack is installed. New functionality is added in new versions so

schemas change, tables change, new tables are added, and so on.

 These rights might be required the first time a discovery is run if tables must be created. All

subsequent discoveries run without the elevated rights.

 These rights might be required the first time a firmware update is performed if tables must be

created. All subsequent firmware upgrades run without the elevated rights.

 These rights might be required the first time a data synchronization is performed if tables must be

created because no discoveries have been performed, such as on a brand new installation. All

subsequent data synchronizations run without the elevated rights.

It is possible that the db_ddladmin role is considered an elevated role and violates company policies.

If so, this role must be granted at least temporarily in these cases. Hopefully this role is not considered

elevated and can be assigned permanently. If so, DBO rights are likely permanently removed after the

installation and the HPWJA service initially creates the tables.

HP recommends granting DBO rights for the HPWJA service to completely control its own database.

However, in rare cases where company policy prohibits it, these roles and rights can allow HP Web

Jetadmin to run without DBO rights.

TROUBLESHOOTING

If HP Web Jetadmin is unable to start after attempting to connect to a new database or the original

database continues to appear on startup, use the following troubleshooting steps.

Original database appears on startup

If the original local database still appears on startup, HP Web Jetadmin might not be reading the

DatabaseSettings.config.xml file. To confirm that the file is not being read and processed, open the

file in a text editor and check the Password section. This section should take the password and

encrypt it for security purposes. If the password is still in plain text and the header claims to be

PlainTextPassword, the file is not being read. The reasons that the file is not being read include the

following:

 The filename is incorrect. The filename might have an .xml.xml or .xml.txt extension. If Windows

Explorer is set to hide known extensions, there is a strong chance that the file is named incorrectly

and it is not apparent.

1 2 ... 14 15 16 17 18 19 20 21 22 23 24 ... 29 30

Kommentare zu diesen Handbüchern

Keine Kommentare

HP Web Jetadmin Software Bedienungsanleitung Seite 19

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software HP Web Jetadmin Software