> What is system_administrator_group_id() returning?
buxs=# select system_administrator_group_id() from dual;
system_administrator_group_id
-------------------------------
(1 row)
> Why did you use the user_ids of 1 and 3?
user_id 1: system account
user_id 2: anonymous
user_id 3: first real user added (me -- also an administrator)
> What does "select * from user_group_map where user_id in (1,3);" return?
buxs=# select * from user_group_map where user_id in (1,3);
group_id | user_id | role | registration_date | mapping_user | mapping_ip_address
----------+---------+---------------+------------------------+--------------+--------------------
1 | 1 | administrator | 2001-08-28 22:30:39-05 | 1 | 0.0.0.0
1 | 3 | administrator | 2001-08-28 23:23:08-05 | 1 | 129.62.16.17
<snip other group ids>