[GRASSLIST:4930] db.login

Radim Blazek blazek at itc.it
Wed Nov 24 04:31:05 EST 2004


db.login was added to 5.7. It can be used to set user and password
for driver/database.
WARNING: password is stored as text in $HOME/.grasslogin5

User and password from database definition (db.connect,v.db.connect) is 
no more used.

This change was necessary to allow work in groups. Now it is possible
to give only select privileges to group or others. Typicaly
location   -> database
mapset     -> schema
UNIX user  -> database user
UNIX group -> database group
Then user can grant select on schema to group and public.
Administrators should keep in sync database and UNIX users,
especially don't forget to remove database user if UNIX user
is removed.

If you revoke access to group or others using g.access,
you should also revoke privileges on related database schema.

Please test mysql driver, I don't have a mysql server running.


Radim




More information about the grass-user mailing list