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_at_lfg.com> 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_at_freelists.org [mailto:oracle-l-bounce_at_
> freelists.org] *On Behalf Of *Jeff Chirco
> *Sent:* Tuesday, May 30, 2017 4:24 PM
> *To:* oracle-l_at_freelists.org
> *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_at_gmail.com>
> 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.**
>

--
http://www.freelists.org/webpage/oracle-l