Iz tablice items_print_log obnoviti podatak items.datelastseen.

Pritanje signatura zahtjeda ODBC driver za MySQL i korisnika na bazi sa kojim će se spajati program.

Nazivi korisnika:

• printer_zs - Zatvoreno spremište
• printer - svi ostali printeri, migrirati na nazive

Dodavanje korisnika u MySQL:

dpavlin@koha:~$ mysql -u root mysql

mysql> create user printer_zs identified by 'password_za_ovaj_account' ;
Query OK, 0 rows affected (0.01 sec)

mysql> grant select,insert on koha.items_print_log to 'printer_zs' ;
Query OK, 0 rows affected (0.15 sec)

mysql> grant select on koha.items to 'printer_zs' ;
Query OK, 0 rows affected (0.00 sec)

mysql> grant select on koha.biblio to 'printer_zs' ;
Query OK, 0 rows affected (0.00 sec)

Passwordi za printere nalaze se na zaštićenom wiki-ju: Zebra printer

Provjera:

mysql> select * from tables_priv ;
+------+------+------------+-----------------+----------------+---------------------+---------------+-------------+
| Host | Db  | User      | Table_name     | Grantor       | Timestamp          | Table_priv   | Column_priv |
+------+------+------------+-----------------+----------------+---------------------+---------------+-------------+
| %   | koha | printer   | items_print_log | root@localhost | 2009-03-27 12:12:17 | Select,Insert |            | 
| %   | koha | printer   | items          | root@localhost | 2009-03-27 12:14:38 | Select       |            | 
| %   | koha | printer   | biblio         | root@localhost | 2009-03-27 12:15:03 | Select       |            | 
| %   | koha | printer_zs | biblio         | root@localhost | 2010-03-09 14:26:30 | Select       |            | 
| %   | koha | printer_zs | items          | root@localhost | 2010-03-09 14:26:24 | Select       |            | 
| %   | koha | printer_zs | items_print_log | root@localhost | 2010-03-09 14:26:19 | Select,Insert |            | 
+------+------+------------+-----------------+----------------+---------------------+---------------+-------------+
6 rows in set (0.00 sec)