No question at this time
DBA Top 10
1 M. Cadot 16900
2 A. Kavsek 15000
3 B. Vroman 10300
4 M. Hidayathullah ... 8400
5 T. Boles 4700
6 P. Wisse 4400
7 J. Schnackenberg 3500
8 K. Van Nieuwenhov... 2100
9 A. Hudspith 800
9 T. P 800
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48095
Total active users1706
Act. users last 24h8
Act. users last hour0
Registered user hits last week389
Registered user hits last month1490
Go up

DBMS_SCHEDULER.CREATE_CREDENTIAL
Next thread: views creation errors
Prev thread: TEMP Tablespace queries have given different values

Message Score Author Date
Hi Guys My developer wants to use the DBMS_SCHE...... Tso P Dec 07, 2017, 09:26
Here are my thoughts.... 1) Don't use DBMS_SCHE...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Tim Boles Dec 08, 2017, 15:33

Follow up by mail Click here


Subject: DBMS_SCHEDULER.CREATE_CREDENTIAL
Author: Tso P, South Africa
Date: Dec 07, 2017, 09:26, 7 days ago
Os info: solaris 10
Oracle info: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
Message: Hi Guys

My developer wants to use the DBMS_SCHEDULER.CREATE_CREDENTIAL to schedule some of his jobs that makes reference to the OS.

I suggested that we have a bash job that I will schedule on his behalf but he insists he needs to have it as DBMS_SCHEDULER.

Will it be wise for me to allow this?

Please help!!!

Thanks in advance...

Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: DBMS_SCHEDULER.CREATE_CREDENTIAL
Author: Tim Boles, United States
Date: Dec 08, 2017, 15:33, 6 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Here are my thoughts....

1) Don't use DBMS_SCHEDULER.CREATE_CREDENTIAL because that specific subprogram has been deprecated in 12c

https://docs.oracle.com/database/121/ARPLS/d_sched.htm#ARPLS72260

2) Use DBMS_CREDENTIAL.CREATE_CREDENTIAL procedure if anything.

https://docs.oracle.com/database/121/ARPLS/d_credential.htm#ARPLS73504

3) The "wisdom" IMHO totally depends on the system setup, change control process and monitoring.

Is there a "reason" he needs to use DBMS_SCHEDULER to implement this?

If you use DBMS_SCHEDULER who / what will monitor the job? Who is responsible to make sure it works and continues as scheduled?

Who will control the changes made to this job and how will those changes be implemented.

What user will own this job?

I think you need to understand what this jobs does, why it needs access to the OS, what privileges it needs in the databases. In the end it will depend on your unique situation. If you don't feel comfortable with giving them that permission the make them justify why it can not be done in the manner you want it to be done in.

Regards
Tim
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here