Version 1 (modified by 14 years ago) (diff) | ,
---|
Adding users to groups
Right now, we have to do this directly in the database.
Start by connecting to the database.
Retrieve the user ID from the actor.usr table. In the following example, we get the ID for someone with the first name "Dan" and the last name "Scott". We use the ILIKE operator because names have been entered with all kinds of uppercase / lowercase mixes.
conifer=# SELECT id, family_name, first_given_name, home_ou FROM actor.usr WHERE family_name ILIKE 'Scott' AND first_given_name ILIKE 'Dan%';
This query returns something like:
id | family_name | first_given_name | home_ou -------+--------------+------------------+---------- 666 | Scott | Dan + 103 (1 row)
Okay, that's the user we want. Now we'll grant the user work permissions at the pertinent library; in this case, the library with id 107.
conifer=# INSERT INTO permission.usr_work_ou_map (usr, work_ou) VALUES (666, 107); INSERT 0 1
And then we add this user to the Super circulator permission group (18):
conifer=# insert into permission.usr_grp_map (usr, grp) values (666, 18); INSERT 0 1
Attachments (1)
-
test_screenshot.png (188.0 KB) - added by 13 years ago.
Test screenshot
Download all attachments as: .zip