HP Web Jetadmin Software Instrukcja Użytkownika Pobierz pdf (Strona 18)

Click OK in the Restore dialog, and watch the results. The restore runs for some time, depending on

the amount of data in the backup file, but should complete with a 100% indication. When the restore

is complete, start the HP Web Jetadmin Service, and then use a client to verify that the All Devices list

contains the same number of devices that HP Web Jetadmin contained when it was originally backed

up.

DATABASE RIGHTS

HP Web Jetadmin was designed with the expectation that the HPWJA service has complete control

over the database it creates (DBO rights). As this document describes, when a remote SQL database

is desired, the SQL administrator creates a blank database and provides authentication to the user

who is running the HPWJA service to use the database. Because the database is blank, the first time

the HPWJA service connects to the database, tables must be created that require elevated rights to

create. Therefore, DBO rights on the database are expected so that HP Web Jetadmin can properly

set up the database for use. When upgrades are performed on HP Web Jetadmin or Feature Packs

are installed, it is not uncommon for schemas to be changed, tables to be created, and so on.

Therefore, elevated rights, such as DBO, are expected when upgrades are performed.

DBO rights provide complete control over a single database. Providing DBO rights on the HP Web

Jetadmin database does not provide access to any other databases and does not allow any

administrative tasks on the SQL instance. DBO right just allow HP Web Jetadmin to perform the tasks

it needs to perform on the one database it creates and uses.

That being said, there still might be cases where it is against company policy to assign elevated

rights, such as DBO rights, on any database that is contained on the company SQL farm. Fortunately,

HP Web Jetadmin can run with less than DBO rights after it is installed and the service creates the

required tables. However, keep in mind that under some circumstances, which are described in the

following, elevated rights might need to be reinstated temporarily to perform certain tasks.

HP Web Jetadmin requires the use of the following SQL operations:

 EXECUTE

 SELECT

 DELETE

 INSERT

 UPDATE

 ALTER (See the following description of when these elevated rights are needed.)

 CREATE TABLE (See the following description of when these elevated rights are needed.)

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

Brak uwag

HP Web Jetadmin Software Instrukcja Użytkownika Strona 18