summaryrefslogtreecommitdiffstats
path: root/database/postgresql/pgsql-common.c
diff options
context:
space:
mode:
authorDavid Sommerseth <dazo@users.sourceforge.net>2012-01-05 19:49:17 +0100
committerDavid Sommerseth <dazo@users.sourceforge.net>2013-06-13 01:01:55 +0200
commitf3c6505df85d22706e8a8a849ead71bb10246cbe (patch)
treee41b47becd2ccb76cdcb7beadd9a2a23f582757a /database/postgresql/pgsql-common.c
parent9e34f375787fb267e3c6e735590abf25efb3d63b (diff)
downloadeurephia-f3c6505df85d22706e8a8a849ead71bb10246cbe.tar.gz
eurephia-f3c6505df85d22706e8a8a849ead71bb10246cbe.tar.xz
eurephia-f3c6505df85d22706e8a8a849ead71bb10246cbe.zip
Add an SQL VIEW for updating users.last_accessed more safely
It's not ideal to let the eurephia-auth user have write access to the users table. This view will allow the eurephia-auth user only to touch users.last_accessed; and this value will be enforced to be CURRENT_TIMESTAMP. Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
Diffstat (limited to 'database/postgresql/pgsql-common.c')
0 files changed, 0 insertions, 0 deletions