Changeset 38134 for trunk/ippTools/share/pstamptool_listuser.sql

Timestamp:

Apr 16, 2015, 2:01:54 PM (11 years ago)

Author:

bills

Message:

Add functions to extract the contents of 3 new tables
pstampUser pstampUserDomain and pstampAccessLevel.

pstampUserDomain sets integer accessLevel value for users with email addresses from
the specified domain. For example ifa.hawaii.edu

pstampUser may be used to override the domains values for specific users. For example
mops@…

pstampAccessLevel has primary key(proj_id, accessLevel) and a set of date limits mjd_min and
mjd_max. We can use this to look up the range of dates that a user with a given accessLevel
may access for the given project. (gpc1, gpc2, etc)

File:

• trunk/ippTools/share/pstamptool_listuser.sql (added)