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)