You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Deleted Permission list showing in the query

1 reply [Last post]
Guest's picture
Guest

Hi,
I have deleted one permission list from Main Menu > PeopleTools > Security > Delete Permission list navigation . But still while i run the below mentioned query it is showing the permission list.

SELECT B.DEPTID, A.DESCR, B.SETID, B.ROWSECCLASS,A.SETID,A.DEPTID,A.EFFDT
FROM PS_SCRTY_TBL_DEPT B, .PS_DEPT_TBL A
WHERE B.DEPTID = '0000014296'
AND A.EFFDT =
(SELECT MAX(A_ED.EFFDT) FROM PS_DEPT_TBL A_ED
WHERE A.SETID = A_ED.SETID
AND A.DEPTID = A_ED.DEPTID
AND A_ED.EFFDT <= CURRENT DATE)
AND A.SETID = B.SETID
AND B.DEPTID = A.DEPTID
AND A.SETID = 'USALL '
ORDER BY 4, 1

Please suggest me why the permission lists are showing after deletion also?

rahulkhandelw's picture
User offline. Last seen 9 years 28 weeks ago. Offline
Joined: 10/16/2009
Posts: 34
Re: Deleted Permission list showing in the query

This is happening beacause when u delete permission list it deletes from data from peopletools tablel PSCLASSDEFN not from application table PS_SCRTY_TBL_DEPT .