RE: [sqr-users] Row Level Security

["Alexander, Steve" <Steve.Alexander@ci.sj.ca.us>]

I assume you're talking about a Peoplesoft page.  You'll probably get more
and better responses from a Peopletools discussion group like
http://www.openitx.com/g/peopletools-l.asp.  But here's my two cents.

In some cases you can take advantage of SETID, starting with Peoplesoft HR
version 7.5.  Some Peoplesoft lookup tables (e.g. PS_DEPT_TBL,
PS_JOBCODE_TBL) have SETID as their first key field.  The purpose of which
is to offer a different list of DEPTID or JOBCODE values for different
employees.  This works if your users are restricted by the department tree,
and the SETIDs are assigned by department.

More generally, you can create a view to support the drop down box.  The
view could be a join between the prompt table and the security table.  Take
a look at the SQL generated by the Query Manager to see examples.

-----Original Message-----
From: Ashish Bhatt [mailto:ashish_bhatt@hotmail.com]
Sent: Wednesday, June 11, 2003 3:40 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Row Level Security


Hi All,

I hope you are doing fine today.

I have a drop box field on a Page. Depending on the login user role I want 
to control the display values of the drop down box on the Page.

Has anyone done this ? If yes, please reply ASAP.

Thanks in advance.

Have a nice day and great week.

Regards.

Ashish Bhatt.

_________________________________________________________________
Take a break! Find destinations on MSN Travel. http://www.msn.com.sg/travel/

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users