08-10-2010 2:54 AM
Hi ,
I have a scenario user1 - end user
and User 2 Power user,
Power user creat queries and assign to end users through folder role .
In power user role s_usr_agr object have folder role x1 with create/change/delete/assign/ ..
Folder Role X1 assigned to both End and power users , we have scenario power user should delete a query from folder role which it should get update all folder role X got assigned to users .
I am trying to delete from query designer or i refresh the role again it is showing
Edited by: raom78 on Aug 9, 2010 9:54 PM
08-10-2010 4:04 AM
08-10-2010 4:19 AM
Now i need a help to delete a query from folder role which got assigned to end user ..
08-10-2010 4:32 AM
08-10-2010 4:39 AM
I have a scenario user1 - end user
and User 2 Power user,
Power user creat queries and assign to end users through folder role i.e X1 .
FYI In power user role s_usr_agr object have folder role x1 with create/change/delete/assign/ ..where as in end user activity display and role -*
Folder Role X1 assigned to both End and power users ,
we have scenario like, *power user should able to delete a query from folder role which was assigned to both end and power user . becoz power user /super user need to delete a query from folder X1 ..so that end users should not able to see the query
I am trying to delete from query designer or i refresh the role again it is not deleting
Edited by: raom78 on Aug 9, 2010 11:41 PM
08-10-2010 5:03 AM
Hi Ramo,
Once you have deleted then try to do user comparsion and check whether it is deleted or not.
Thanks,
Sri
08-10-2010 5:16 AM
But power user doesn't have any user comparison authorizations (i.e PFCG ) ..
I need only option to delete a query from folder role,
08-10-2010 5:40 AM
rao,
Why will u do user comparsion for power user role?
end user is having the role folder - once you delete you have to do user comparsion-right.
then only it will get updated -right
Thanks,
Sri
08-10-2010 10:29 AM
Hi Raom,
A folder role should be a blank role with no authorization objects
Since your problem is that the query is not getting deleted via Query Designer, there is turn around fix for this.
You create a role with transaction PFCG & in the Authorization Object S_USER_AGR, give only that folder role X1 name & assign it to the Power User.
In this case, the power user will access PFCG & can adminster only the Folder Role X1 for which he/she is authorized, he can then delete the queries from here
Edited by: Siddhartha Varma on Aug 10, 2010 10:32 AM