C
ctd
Hi,
I have a client requirement to add new resource using PWA only. With the
following requirement, I'm not sure if I should add new resources under the
RBS look up table or just add them using the Manage Users/Groups option.
Level 1 - Department
Level 2 - Group (with security permission)
Level 3 - Users/Resources.
The requirement is that resources under one department can only view
projects under that department, except for those in the Admin group can view
projects across departments. Also another requirement is that if I select a
department (level 1) and a group (level 2), I should be able to see all
resources (level 3) under it.
To test out, I created a RBS look up table with 3 levels. I also created
new users using Manage users/groups option and assign the correct level of
RBS to them.
Now when I tried to look into the published database, I was able to see the
RBS look up table values with all 3 levels, but for all users being added
only thru the manage users/groups option, I saw their name under the resource
table, their group in the "MSP_web_security_group" table, but can't find
their department anywhere. So, my question:
1. Between RBS look up table and Manage Users/Group option, what is the
correct way to add a new user with group level/permission and depart. level
info ?
2. When I create a RBS look up table, should the entity be "resource" or
"project" ?
so that if I create a new project thru PSI, I will be able to assign
resource and any custom field to that project.
3. How do I retrieve a list of resources if I know their department/group
value ?
If I add resources thru RBS look up table, then it's just a simple query.
But if I add resources thru Manage User/Group option, I don't have the answer
yet.
4. If I follow the RBS structure above (dept - group - user), then how can I
overwrite the permission for any new admin - who doesn't belong to any dept.
and should be able to view all projects.
Sorry for a long post, and thanks in advance.
ctd
I have a client requirement to add new resource using PWA only. With the
following requirement, I'm not sure if I should add new resources under the
RBS look up table or just add them using the Manage Users/Groups option.
Level 1 - Department
Level 2 - Group (with security permission)
Level 3 - Users/Resources.
The requirement is that resources under one department can only view
projects under that department, except for those in the Admin group can view
projects across departments. Also another requirement is that if I select a
department (level 1) and a group (level 2), I should be able to see all
resources (level 3) under it.
To test out, I created a RBS look up table with 3 levels. I also created
new users using Manage users/groups option and assign the correct level of
RBS to them.
Now when I tried to look into the published database, I was able to see the
RBS look up table values with all 3 levels, but for all users being added
only thru the manage users/groups option, I saw their name under the resource
table, their group in the "MSP_web_security_group" table, but can't find
their department anywhere. So, my question:
1. Between RBS look up table and Manage Users/Group option, what is the
correct way to add a new user with group level/permission and depart. level
info ?
2. When I create a RBS look up table, should the entity be "resource" or
"project" ?
so that if I create a new project thru PSI, I will be able to assign
resource and any custom field to that project.
3. How do I retrieve a list of resources if I know their department/group
value ?
If I add resources thru RBS look up table, then it's just a simple query.
But if I add resources thru Manage User/Group option, I don't have the answer
yet.
4. If I follow the RBS structure above (dept - group - user), then how can I
overwrite the permission for any new admin - who doesn't belong to any dept.
and should be able to view all projects.
Sorry for a long post, and thanks in advance.
ctd