Oh yeah good call on the create like.
On Wed, May 31, 2017 at 12:20 PM, Le, Binh T. <Binh.Le@xxxxxxx> wrote:
Hi Jeff,
I will need do a little more research regarding the second part.
Though I pretty sure the user cannot change your job, but that would not
stop them create-like and then change it in his/her own login and then use
the same preferred credential to run it.
I just have to do a little more research.
Thanks,
Binh
*From:* Jeff Chirco [mailto:backseatdba@xxxxxxxxx]
*Sent:* Wednesday, May 31, 2017 3:15 PM
*To:* Le, Binh T. <Binh.Le@xxxxxxx>; oracle-l@xxxxxxxxxxxxx
*Subject:* Re: EM Job to flashback test database
Thanks for the reply. Do you have any insight about my second part and
not allowing them to make changes to sql code but allow a parameter to be
passed?
Thanks
On Wed, May 31, 2017 at 11:22 AM, Le, Binh T. <Binh.Le@xxxxxxx> wrote:
You can create preferred credential for the database and also preferred
credential for the host and then grant to the user to use it.
Yes. There is global credential but mostly I use it for multiple targets
, same target type have the same credential so I don’t have to create
multiple the same preferred credential.
*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@
freelists.org] *On Behalf Of *Jeff Chirco
*Sent:* Tuesday, May 30, 2017 4:24 PM
*To:* oracle-l@xxxxxxxxxxxxx
*Subject:* Re: EM Job to flashback test database
***This email is from an external source. Only open links and attachments
from a Trusted Sender.***
Forgot to mention using EM 13.2 and database in question are 11.2.0.4
On Tue, May 30, 2017 at 1:22 PM, Jeff Chirco <backseatdba@xxxxxxxxx>
wrote:
I need some help with an Enterprise Manager job. I would like to create a
job that would allow developers to flashback certain dev/test databases. I
don't want to give them access to the server to shutdown/start up the
database so I was hoping to do it throuhg an EM job. I've created the job
to do this using my own credentials but I have two questions.
1. The job requires a credential to run as. One for the server and another
for the database. How do I give them access to a credential to use since
they can't use their own. Is this a global credential?
2. The job I created is by using a SQL Script. Is there a way to prevent
the user to not make any changes to the code section of the script but all
them to enter a parameter. The parameter would be a date or restore point.
Thanks,
Jeff
Notice of Confidentiality: **This E-mail and any of its attachments may
contain
Lincoln National Corporation proprietary information, which is privileged,
confidential,
or subject to copyright belonging to the Lincoln National Corporation
family of
companies. This E-mail is intended solely for the use of the individual or
entity to
which it is addressed. If you are not the intended recipient of this
E-mail, you are
hereby notified that any dissemination, distribution, copying, or action
taken in
relation to the contents of and attachments to this E-mail is strictly
prohibited
and may be unlawful. If you have received this E-mail in error, please
notify the
sender immediately and permanently delete the original and any copy of
this E-mail
and any printout. Thank You.**
Notice of Confidentiality: **This E-mail and any of its attachments may
contain
Lincoln National Corporation proprietary information, which is privileged,
confidential,
or subject to copyright belonging to the Lincoln National Corporation
family of
companies. This E-mail is intended solely for the use of the individual or
entity to
which it is addressed. If you are not the intended recipient of this
E-mail, you are
hereby notified that any dissemination, distribution, copying, or action
taken in
relation to the contents of and attachments to this E-mail is strictly
prohibited
and may be unlawful. If you have received this E-mail in error, please
notify the
sender immediately and permanently delete the original and any copy of
this E-mail
and any printout. Thank You.**
