OraFAQ Forum: Security » Restricting Form Items based on user

Home » RDBMS Server » Security » Restricting Form Items based on user

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Restricting Form Items based on user [message #113048]

Wed, 30 March 2005 14:53

Steve Corey
Messages: 336
Registered: February 2005
Location: RI

Senior Member

Hello! I am fairly new to the concept of 'Oracle Security' so excuse me if I do not express myself correctly. I have a requirement to restrict a list of values in a form based on two variables: 1) who the current user is and 2) who the current user has assigned under them. I can obtain who the current user through a custom procedure a co-worker wrote, but how do I tell who is "assigned" to that person? The idea is that we are choosing local administrators who are responsible for say, entering time for somebody in their department. The local administrator would be able to enter our timecard system and in a drop-down list of values they should be able to see themselves as well as the employees "assigned" to them. I would think that this is done through the use of user_id's or person_id's or both, but I am not sure on how to go about this.

To clarify my own confusion, this does not have anything to do with subfunctions does it?

Thanks for any help!
Regards,
Steve

Report message to a moderator

Re: Restricting Form Items based on user [message #113360 is a reply to message #113048]

Fri, 01 April 2005 11:22

Steve Corey
Messages: 336
Registered: February 2005
Location: RI

Senior Member

OK, I've figured out how to get the user and the assignees out of the DB and primed for analyzation in my form. If anyone is interested in how I accomplished this (well, I'll let you know when its done) leave a message.

Steve

Report message to a moderator

Previous Topic:	Oracle Label Security
Next Topic:	password problem...?..urgent plss

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 04 19:09:22 CDT 2025