Secure user to view/update employees in a specific location
Subject: [orahrms-l] HR:Security
From: Greg.Hoover@IFLYATA.COM
Date: Thu, 12 Aug 1999 10:57:22 -0500
Good morning.
We have a specific need to be able to build a secure user that can only view
/ update employees that work in a specific location.
I spoke with Oracle about this yesterday, and their response was that you
have to use either the organizational hierarchy and/or the positional
hierarchy method to create a list of valid employees for a secure user to
see (I suspected as much).
What I am considering is creating a new hierarchy structure that contains
all the cost centers (every employee is assigned to a cost center), assign
this hierarchy to a secure user, letting the SECGEN program build the
complete list of employees that are viewable by that user, and then running
a secondary job that would delete the employees (from the per_person_list
table) that the secure user should not be able to view.
From everything that I can think of and have looked at, this should work,
and it's fairly straight forward solution.
Has anyone come up with a solution to this "problem" or does anyone have any
insight as to whether I am proposing will work ?
Thanks for your time.
Greg
Subject: Re: [orahrms-l] HR:Security
From: "Ken Conway" ken.conway@bosscorporation.com
Date: Thu, 12 Aug 1999 11:19:02 -0500
Greg:
Your approach should work OK. I have not personally altered the
per_person_list table to support security in the past. However, I have
notes that indicate this is a safe approach. We plan to do something
similar on an upcoming implementation.
Hope this helps,
Ken
Ken Conway
BOSS Corporation
Better Organization Service Solutions
(214) 495-7654 Voice
(214) 495-7543 Fax
www.bosscorporation.com
Subject: [orahrms-l] RE: HR:Security
From: "Kevin Jarrett" kejarr@copelco.com
Date: Fri, 13 Aug 1999 07:39:22 -0400
We are HR only and get around this obstacle by using "Payroll" security. We
assigned each of our physical locations a unique payroll name, and use that
in the security profile to control who sees what.
Works great. It may or may not for you, especially if you're a Payroll
client.
Any questions, email me...
-kj-
Kevin Jarrett Copelco Capital, Inc.
E-Commerce Project Manager Mount Laurel, NJ USA
kejarr@copelco.com http://www.copelco.com
Subject: Re: [orahrms-l] HR:Security
From: "George Richardson" RICGE01@fallon-clinic.com
Date: Fri, 13 Aug 1999 09:35:23 -0400
The only caveat I can see to this procedure would be if you are running listgen everyday as you
should, you would also have to run your procedure everyday. I THINK!
George Richardson
Database Administrator
x54492
Secured User - Grant permission not working
From:"Barnett, Janet L." jlbarnet@mountaineergas.com
Date:19th August 1999
Subject: Secured Users
I am trying to create responsibilities that only look at certain
organizations.
I have created the responsibility.
I have created the security profile and tied these together.
I have updated the system profile option.
I am using version 11.02. I tried to runt the Grant permissions to
roles process but it says:
the user or role HR_Secure_user does not exist.
How do I create this
user? Is this something the DBA does?
If so, what does he do?
Thanks for your help.
Janet Barnett
Mountaineer Gas Company
From: "Lewis Cunningham" LCunningham@gwmail.valencia.cc.fl.us
Date:19th August 1999
Subject: Re: [orahrms-l] Secured Users
Your DBA needs to run the ROLEGEN process. It's a script. This should
have been done on install.
Lewis
From: Laurie Bosley lbosley@solbourne.com
Date; 20th August 1999
Subject: RE: [orahrms-l] Secured Users
Janet, this sounds like the same problem I was having. Grant Permissions to
Roles is actually obsolete in release 11.02.
Oracle support had us apply patches 765384 and 899496. They also had us
check that we had run version 110.4 or higher of payactn.odf.
After we completed these steps, security profiles worked perfectly. Good
luck.
Laurie K. Bosley, PMP
Solbourne
1790 W. 38th St. Suite 300
Boulder, CO 80301
lbosley@solbourne.com
888-704-5928 (pager)
303-448-6077 (voice mail)
303-417-2820 (fax)
Two Business Groups in once instance
Date: Tue, 24 Aug 1999 13:02:15 +0200
From: Bert Vandenbussche Bert.Vandenbussche@argus-is.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: PAYROLL :problem with setting up two business groups in one insta
Hi,
We're trying to set up two business groups in one instance, and are
experiencing some problems doing so :
- If we are setting up elements in our second business group that have the
same name as elements set up in the first business group (f.ex. Salary), the
database items are not created for this new element, somehow the procedure
responsible for creating those dbi's doesn't recognise that those elements
belong to a different business group.
- When trying to apply a TYE patch (p866730_1100) we run in a similar
problem (my guess), the patch hangs in the procedure
HRDYNDBI.REBUILD_ELE_INPUT_BAL('Y').
Support is working on it, but seen our time constraints, I'm hoping somebody
is familiar with this problem and can help us foreward.
Cheers,
Bert
Bert Vandenbussche
Senior Oracle HR Consultant
ARGUS
INTEGRATED SOLUTIONS
Dorset House
Regent Park
Kingston Road
Leatherhead
Surrey KT22 7PL
United Kingdom
Phone: +44 (0) 1372 824560
Fax: +44 (0) 1372 824570
bert.vandenbussche@argus-is.com
http://www.argus-is.com