ORACLE, MS-SQL, MySQL 의 DB 보안 설정 방법 문서입니다.
- 계정 관리…………………………………………………………………………………………………………….. 2
- 접근관리………………………………………………………………………………………………………………. 13
- 원격에서 DB 서버로의 접속 제한…………………………………………………………….. 13
- DBA이외의 인가되지 않은 사용자 시스템 테이블 접근 제한 설정……… 15
- 오라클 데이터베이스의 경우 리스너 패스워드 설정…………………………………….. 17
- 불필요한 ODBC/OLE-DB 데이터 소스와 드라이브 제거………………………………. 18
- 일정 횟수의 로그인 실패 시 잠금 정책 설정……………………………………………. 19
- 데이터베이스의 주요 파일 보호 등을 위해 DB 계정의 umask를 022 이상으로 설정 20
- 데이터베이스의 주요 설정파일, 패스워드 파일 등 주요 파일들의 접근 권한 설정 21
- 관리자 이외의 사용자가 오라클 리스너의 접속을 통해 리스너 로그 및 trace 파일에 대 한 변경 권한 제한……………………………………………………………………………………… 23
- 옵션관리………………………………………………………………………………………………………………. 24
- 응용프로그램 또는 DBA 계정의 Role이 Public으로 설정되지 않도록 조정… 24
- OS_ROLES, REMOTE_OS_AUTHENTICATION, REMOTE_OS_ROLES를 FALSE로 설정.. 25
- 패스워드 확인함수가 설정되어 적용되는가?……………………………………………… 26
- 인가되지 않은 Object Owner가 존재하지 않는가?………………………………………… 28
- grant option이 role에 의해 부여되도록 설정………………………………………………. 29
- 데이터베이스의 자원 제한 기능을 TRUE로 설정………………………………………. 30
- 패치관리………………………………………………………………………………………………………………. 31
- 로그관리………………………………………………………………………………………………………………. 37
Audit Table은 데이터베이스 관리자 계정에 속해 있도록 설정 37
< 내용 확인 >
DBMS별 보안 설정 방법(ORACLE+MSSQL+MYSQL)
Did you enjoy taking part in Dragon Age?
Here you get the finest of the sports activities activities.
You possibly can try your hand on recreation fishing, golf and
even scuba diving.
I have read so many articles regarding the blogger
lovers except this piece of writing is truly a pleasant
paragraph, keep it up.
I like the valuable information you provide to your articles.
I’ll bookmark your weblog and test once more right here frequently.
I am relatively sure I will learn many new stuff proper right here!
Good luck for the following!
Fantastic beat ! I would like to apprentice while you amend your website, how could
i subscribe for a blog web site? The account aided
me a acceptable deal. I had been a little bit acquainted of this your broadcast provided bright
clear idea
Genuinely no matter if someone doesn’t know after that its up
to other users that they will help, so here it takes
place.
I am really loving the theme/design of your web site.
Do you ever run into any web browser compatibility issues?
A number of my blog readers have complained
about my blog not operating correctly in Explorer but looks great in Safari.
Do you have any ideas to help fix this problem?
In fact no matter if someone doesn’t be aware of after that its up to other
users that they will help, so here it occurs.
I see you don’t monetize your page, don’t waste your
traffic, you can earn additional cash every month.
You can use the best adsense alternative for any type
of website (they approve all websites), for more details simply
search in gooogle: boorfe’s tips monetize your website
My spouse and I absolutely love your blog and find most of your post’s to be just what I’m looking
for. Does one offer guest writers to write content in your case?
I wouldn’t mind composing a post or elaborating on some of the subjects you write about here.
Again, awesome web site!
Hello there, You have done a fantastic job. I’ll certainly
digg it and personally suggest to my friends. I’m confident they will be benefited from this web site.
Keep on writing, great job!
This is a topic which is close to my heart…
Cheers! Exactly where are your contact details though?
Good day! I could have sworn I’ve been to this site before but after browsing through some of the post I realized it’s new to me.
Nonetheless, I’m definitely delighted I found it and I’ll be book-marking and checking back frequently!
you are actually a excellent webmaster. The web site loading pace is incredible.
It kind of feels that you are doing any distinctive trick.
In addition, The contents are masterwork. you’ve done a magnificent activity on this matter!
Hi everyone, it’s my first pay a visit at this site, and paragraph is
in fact fruitful in support of me, keep up posting these types of
articles.
Hey There. I found your blog using msn. This is a really smartly written article.
I will make sure to bookmark it and return to learn extra of your
helpful info. Thanks for the post. I will definitely return.
Heya i am for the first time here. I found this board and I find It really useful & it
helped me out a lot. I hope to give something back and help others
like you helped me.
What’s Taking place i’m new to this, I stumbled upon this I’ve found It absolutely useful and it
has aided me out loads. I’m hoping to give a contribution & aid different users like its helped me.
Good job.
Great post and straight to the point. I am not sure if
this is in fact the best place to ask but do you people have any
ideea where to hire some professional writers?
Thx 🙂
Great work! This is the type of info that should be shared across the web.
Shame on the seek engines for now not positioning this submit upper!
Come on over and visit my site . Thanks =)
thời trang dành cho phái nữ việt được xem là trong những nền năng động
độc nhất vô nhị nhất. không bắt buộc nhìn chỗ nào xa thì ngay
từ khi bước ra thế giới qua các tầm ảnh được chụp từ năm 1945.
Nét văn hóa rất là quan trọng được xuất phát từ đấy.
Hai vật phẩm cam kết được giá trị vĩnh
viễn đấy là chiếc áo dài phối hợp cùng theo với nón thúng quai thao.
Hòa trộn nhưng không hòa tan phải Phong cách giày dép truyền thống của việt nam
vẫn được giữ vững theo năm tháng. Công chúng chỉ bắt đầu đón nhận những trang phục này kể từ lúc các điểm giao
xoa xuất hiện. dù rằng lớn mạnh chậm tuy nhiên với sự nhạy bén của tôi,
thời trang việt vẫn không hề thiếu quần áo xinh.
cộng điểm lại những thành tựu mà thời trang việt đã đạt được trong quãng khoảng thời
gian qua để thấy rằng năng động việt đang
đổi khác đa dạng ra sao.