Halim, a Georgia Tech graduate Senior Database Engineer/Data Architect based in Atlanta, USA, is an Oracle OCP DBA and Developer, Certified Cloud Architect Professional, and OCI Autonomous Database Specialist. With extensive expertise in database design, configuration, tuning, capacity planning, RAC, DG, scripting, Python, APEX, and PL/SQL, he combines technical mastery with a passion for innovation. Notably, Halim secured 16th place worldwide in PL/SQL Challenge Cup Playoff on the year 2010.
Thursday, May 19, 2011
Wednesday, May 18, 2011
Security Check List or Security issue of Oracle Database
Security Check List or Security issue of Oracle Database
==========================================
1 : Change the password for SYS and SYSTEM.
2 : Lock, remove or change passwords for default unused accounts.
3 : Check privileges and limit SYS privilege.
4 : Set REMOTE_OS_AUTHENT init.ora parameter to FALSE
for avoiding remote users OS authentication.
5 : Protect the dictionary from unauthorized users.
such as Set O7_DICTIONARY_ACCESSIBILITY to FALSE.
6 : Revoke privileges from PUBLIC where not necessary
Such as for example for the UTL_FILE package.
7 : Verify database file security
8 : Limit the number of OS users on the database host
9 : Remove unnecessary services from the database host (e.g. FTP).
10: On a regular basis, check Metalink for Security alerts and patches.
or here http://www.oracle.com/technetwork/topics/security/alerts-086861.html
11. How well compartmentalized is your system ?
12. Do people have administrative passwords who really do not need them ?
13. Change passwords often, then monitor and audit. It is worth the extra time and
overhead.
14. Physical security is vital, as always. Your server is safely locked away, but
how about your backup tapes ?
15. If you needed to restore your system tomorrow, do you have everything you need
offsite ?
16. you can use Database Scanner 3.0 from Internet Security Systems (ISS: www.iss.net/products)
another one is here Secure.Data from Protegrity (www.protegrity.com)
==========================================
1 : Change the password for SYS and SYSTEM.
2 : Lock, remove or change passwords for default unused accounts.
3 : Check privileges and limit SYS privilege.
4 : Set REMOTE_OS_AUTHENT init.ora parameter to FALSE
for avoiding remote users OS authentication.
5 : Protect the dictionary from unauthorized users.
such as Set O7_DICTIONARY_ACCESSIBILITY to FALSE.
6 : Revoke privileges from PUBLIC where not necessary
Such as for example for the UTL_FILE package.
7 : Verify database file security
8 : Limit the number of OS users on the database host
9 : Remove unnecessary services from the database host (e.g. FTP).
10: On a regular basis, check Metalink for Security alerts and patches.
or here http://www.oracle.com/technetwork/topics/security/alerts-086861.html
11. How well compartmentalized is your system ?
12. Do people have administrative passwords who really do not need them ?
13. Change passwords often, then monitor and audit. It is worth the extra time and
overhead.
14. Physical security is vital, as always. Your server is safely locked away, but
how about your backup tapes ?
15. If you needed to restore your system tomorrow, do you have everything you need
offsite ?
16. you can use Database Scanner 3.0 from Internet Security Systems (ISS: www.iss.net/products)
another one is here Secure.Data from Protegrity (www.protegrity.com)
Labels:
security
Monday, May 16, 2011
How to Delete a File from the O/S from oracle developer Forms ?
How to Delete a File from the O/S from oracle developer Forms ?
---------------------------------------------------------------
1)
The first way to delete a file on the O/S is to use the HOST command. The HOST
built-in allows to execute an indicated operating system command.
Syntax (see forms on-line help)
PROCEDURE HOST(system_command_string VARCHAR2);
PROCEDURE HOST(system_command_string VARCHAR2,screen_action NUMBER);
On a Windows platform your code would look like :
HOST ( 'del C:\temp\temp1.lis', NO_SCREEN );
On a Unix platform you code would look like :
HOST ( 'rm /tmp/temp1.lis', NO_SCREEN );
As this solution is based on the HOST command it applies to all platforms.
2).
Another way to delete a file form the O/S is to use for Client/Server
D2kWutil: WIN_API_UTILITY.DELETE_FILE
or for Webforms
webUtil: webutil_file.delete_file.
---------------------------------------------------------------
1)
The first way to delete a file on the O/S is to use the HOST command. The HOST
built-in allows to execute an indicated operating system command.
Syntax (see forms on-line help)
PROCEDURE HOST(system_command_string VARCHAR2);
PROCEDURE HOST(system_command_string VARCHAR2,screen_action NUMBER);
On a Windows platform your code would look like :
HOST ( 'del C:\temp\temp1.lis', NO_SCREEN );
On a Unix platform you code would look like :
HOST ( 'rm /tmp/temp1.lis', NO_SCREEN );
As this solution is based on the HOST command it applies to all platforms.
2).
Another way to delete a file form the O/S is to use for Client/Server
D2kWutil: WIN_API_UTILITY.DELETE_FILE
or for Webforms
webUtil: webutil_file.delete_file.
How to Enable SQL_TRACE in oracle Forms developer ?
How to Enable SQL_TRACE in oracle Forms developer ?
--------------------------------------------------
In order to enable a Forms session level SQL_TRACE do the following:
Place the following line of code in a When-New-Form-Instance Trigger in
the first form that is run in your application:
FORMS_DDL('ALTER SESSION SET SQL_TRACE=TRUE');
A trace file will be generated on the database server in the directory specified
by the database parameter user_dump_dest.
Labels:
spfile
DBA jobs in Bangladesh
DBA jobs/future in Bangladesh specially Oracle DBA
=====================================
also trying to write on this topics.
just for test
DBA jobs in Dubai
oracle dba jobs in dubai
dba jobs in saudi arab
dba jobs in usa
dba jobs in uk
=====================================
also trying to write on this topics.
just for test
DBA jobs in Dubai
oracle dba jobs in dubai
dba jobs in saudi arab
dba jobs in usa
dba jobs in uk
Labels:
Jobs
Oracle in Bangladesh (Growing future day by day)
Oracle in Bangladesh (Growing future day by day)
=================================================
I will write a details article on this subject. Now i am collecting data or information about this topics. you can help me.
Main Contact Person
====================
Contact with Aon Ali for Oracle University Corporate Training Queries in Bangladesh
He is in charge now for the Bangladeshies . His contact info is
E-mail: aon.ali.siddiqui@oracle.com
Cellular: +92 300 2003399
Address : Suite # 306 & 307, The Forum
Khayaban-e-Jami, Block No 9,
Clifton, Karachi.
More info see here:-
http://www.oracle.com/as/corporate/contact/bangladesh-316183-en-as.html
Oracle University- Authorized Training Partners in Bangladesh
1) Workforce Development Program Members (WDP) - For Individual Training
I . IBCS-PRIMAX Software (Bangladesh) Ltd.
House No. 51, Road No. 10A (North of Abahoni Field)
Dhanmondi R/A, Dhaka-1209, Bangladesh
Tel: 880-2-8126931, 9144549, 8110699, 9141876, 9143775
karahman@ibcs-primax.com
II . IT Bangla Limited
32, Topkhana Road, Chattagram Bhaban (3rd Flr), Dhaka-1000, Bangladesh.
Phone: 9558519, 9557053
Fax: 9553937
Email:education@itbangla.netTechno-Ed
2) Oracle University – Oracle Approved Education Center (OAEC)
IBCS-PRIMAX Software (Bangladesh) Ltd.
House No. 51, Road No. 10A (North of Abahoni Field)
Dhanmondi R/A, Dhaka-1209, Bangladesh
Tel: 880-2-8126931, 9144549, 8110699, 9141876, 9143775
karahman@ibcs-primax.com
3) Oracle University- Education Resellers
IBCS-PRIMAX Software (Bangladesh) Ltd
Oracle jobs in Bangladesh: visit...
http://www.careerjet.com.bd/oracle-jobs.html
Oracle partners in Bangladesh
==============================
=================================================
I will write a details article on this subject. Now i am collecting data or information about this topics. you can help me.
Main Contact Person
====================
Contact with Aon Ali for Oracle University Corporate Training Queries in Bangladesh
He is in charge now for the Bangladeshies . His contact info is
E-mail: aon.ali.siddiqui@oracle.com
Cellular: +92 300 2003399
Address : Suite # 306 & 307, The Forum
Khayaban-e-Jami, Block No 9,
Clifton, Karachi.
More info see here:-
http://www.oracle.com/as/corporate/contact/bangladesh-316183-en-as.html
Oracle University- Authorized Training Partners in Bangladesh
1) Workforce Development Program Members (WDP) - For Individual Training
I . IBCS-PRIMAX Software (Bangladesh) Ltd.
House No. 51, Road No. 10A (North of Abahoni Field)
Dhanmondi R/A, Dhaka-1209, Bangladesh
Tel: 880-2-8126931, 9144549, 8110699, 9141876, 9143775
karahman@ibcs-primax.com
II . IT Bangla Limited
32, Topkhana Road, Chattagram Bhaban (3rd Flr), Dhaka-1000, Bangladesh.
Phone: 9558519, 9557053
Fax: 9553937
Email:education@itbangla.netTechno-Ed
2) Oracle University – Oracle Approved Education Center (OAEC)
IBCS-PRIMAX Software (Bangladesh) Ltd.
House No. 51, Road No. 10A (North of Abahoni Field)
Dhanmondi R/A, Dhaka-1209, Bangladesh
Tel: 880-2-8126931, 9144549, 8110699, 9141876, 9143775
karahman@ibcs-primax.com
3) Oracle University- Education Resellers
IBCS-PRIMAX Software (Bangladesh) Ltd
Oracle jobs in Bangladesh: visit...
http://www.careerjet.com.bd/oracle-jobs.html
Oracle partners in Bangladesh
==============================
| |||||||||||||||||||||||
| |||||||||||||||||||||||
| |||||||||||||||||||||||
| |||||||||||||||||||||||
| |||||||||||||||||||||||
| |||||||||||||||||||||||
| |||||||||||||||||||||||
| |||||||||||||||||||||||
| |||||||||||||||||||||||
|
Subscribe to:
Posts (Atom)
My Blog List
-
-
-
ASSM states3 weeks ago
-
UKOUG Discover 20241 month ago
-
-
-
-
-
-
-
-
Moving Sideways8 years ago
-
-
Upcoming Events...11 years ago
-