Hi,
to get a shared group calendar I created an account with NO "group" role
set. I the created accounts and gave them all full rights to the group
via a newly defined "is member of" relationship. I did not set any other
relationships.
But now everybody has full rights to everybody.
Here some parts of the database content:
davical=# SELECT * from relationship where from_user = 1001;
from_user | to_user | rt_id
-----------+---------+-------
1001 | 1009 | 12
davical=# select * from relationship_type where rt_id=12;
rt_id | rt_name | rt_togroup | confers | rt_fromgroup
-------+--------------+------------+---------+--------------
12 | is member of | | A |
davical=# select * from role_member where user_no = 1009;
role_no | user_no
---------+---------
(0 rows)
davical=# SELECT get_permissions(1001,1010);
get_permissions
-----------------
A
========
as you can see, get_permissions returns an A for the permission. I guess
there is a bug in the stored procedure but did not look into it.
regards, Andreas
to get a shared group calendar I created an account with NO "group" role
set. I the created accounts and gave them all full rights to the group
via a newly defined "is member of" relationship. I did not set any other
relationships.
But now everybody has full rights to everybody.
Here some parts of the database content:
davical=# SELECT * from relationship where from_user = 1001;
from_user | to_user | rt_id
-----------+---------+-------
1001 | 1009 | 12
davical=# select * from relationship_type where rt_id=12;
rt_id | rt_name | rt_togroup | confers | rt_fromgroup
-------+--------------+------------+---------+--------------
12 | is member of | | A |
davical=# select * from role_member where user_no = 1009;
role_no | user_no
---------+---------
(0 rows)
davical=# SELECT get_permissions(1001,1010);
get_permissions
-----------------
A
========
as you can see, get_permissions returns an A for the permission. I guess
there is a bug in the stored procedure but did not look into it.
regards, Andreas