Oracle SELECT TRIGGER

by Nurgün Özgür 23. September 2009 23:16

MSSQL'da olmayan ve Oracle mümkün olan SELECT TRIGGER'dan bahsetmek istiyorum.

Aslında bunu yapabilmek için trigger yerine policy yaratılıyor(Fine-grained Auditing).

1. Önce bir policy eklemeniz gerekiyor

BEGIN

      DBMS_FGA.ADD_POLICY (OBJECT_SCHEMA=>'COMPANY', OBJECT_NAME=>'PAYROLL', POLICY_NAME=>'PAYROLL_ACCESS');

END;

2. Log işlemini tetikleyecek SELECT'i çalıştırın.

Örnek: çalışanların maaşlarını öğrenmeye çalışalım.

 

SELECT * FROM COMPANY.PAYROLL;

 

3. Select sonucunda oluşan Log'u inceleyin. Burada maaş tablosunu kim ne zaman ve neler sorguladığını görebiliriz.

SELECT TIMESTAMP, DB_USER, OS_USER, OBJECT_SCHEMA, OBJECT_NAME, SQL_TEXT FROM DBA_FGA_AUDIT_TRAIL;

 

Sonuç:

TIMESTAMP DB_USER OS_USER OBJECT_SHEMA OBJECT_NAME SQL_TEXT

------------  ---------- ---------- ----------------- ----------------  -------------------------------------

23-SEP-09   sysadm  nurgun    COMPANY         PAYROLL          select * from COMPANY.PAYROLL

 

Tags: , ,

Oracle

Comments

3/19/2010 11:27:55 PM #

Valeria Keet

I like the blog, but could not find how to subscribe to receive the updates by email. Can you please let me know?

Valeria Keet United States | Reply

3/20/2010 11:03:59 PM #

Bulgaria Property

I like the blog, but could not find how to subscribe to receive the updates by email.

Bulgaria Property United States | Reply

3/23/2010 2:36:32 AM #

website design edinburgh

I think am just having some problems with subscribing to RSS feed here.

website design edinburgh Poland | Reply

3/23/2010 10:38:53 AM #

black tea

Great article I've just added to my bookmark list.

black tea Poland | Reply

3/28/2010 1:48:49 AM #

Forex Strategie

You address an interesting issue on that stuff. I think you described it in a professional way. I hope you will go further  this way, with your excellent way of writing

Forex Strategie Germany | Reply

4/3/2010 10:24:57 PM #

personal loans

That's good that people are able to get the loan moreover, it opens new chances.

personal loans Canada | Reply

4/5/2010 10:01:53 PM #

Link builder

Just my two cents, but your blog will look much more interesting if you can throw in some pictures.

Link builder United States | Reply

4/6/2010 12:43:59 AM #

Marie Doktor

Well done, you have gained a new fan, resources like the one you mentioned here are very useful to me. I will post a link to this page on my blog. I am sure my visitors will find that very useful, please check out my site sometime and leave me a comment to let me know what you think. Regards, Marie

Marie Doktor United States | Reply

4/17/2010 1:07:07 PM #

Tagesgeldkonditionen

Nice to see, this was really a interesting post. In theory I would like to write like this too. It takes time to creat that brilliant and in addition real effort to write  a excellent article.

Tagesgeldkonditionen United States | Reply

4/23/2010 5:58:38 AM #

antique lamps

What I wouldnt give to have a debate with you about this.  You just say so many things that come from nowhere that Im pretty sure Id have a fair shot.  Your blog is great visually, I mean people wont be bored.  But others who can see past the videos and the layout wont be so impressed with your generic understanding of this topic.

antique lamps United States | Reply

4/24/2010 4:02:45 PM #

discount kitchen appliances

What I dont understand is how youre not even more popular than you are now.  Youre just so intelligent.  You know so much about this subject, made me think about it from so many different angles.  Its like people arent interested unless it has something to do with Lady Gaga!  Your stuffs great.  Keep it up!

discount kitchen appliances United States | Reply

4/27/2010 11:47:21 PM #

Rapidshare

I\'m happy I found this blog, I couldnt discover any info on this subject matter prior to. I also run a site and if you want to ever serious in a little bit of guest writing for me if possible feel free to let me know, i\'m always look for people to check out my site. Please stop by and leave a comment sometime!

Rapidshare United States | Reply

4/28/2010 3:08:36 AM #

http://www.answerspots.com

Write more, thats all I have to say.  Literally, it seems as though you relied on the video to make your point.  You clearly know what youre talking about, why waste your intelligence on just posting videos to your blog when you could be giving us something enlightening to read?

http://www.answerspots.com United States | Reply

4/28/2010 2:32:26 PM #

Medical Forum

For what its worth, the layout is definitely amazing.  You know how to balance writing and images/videos.  However, I cant get over how little you actually bring to light here.  I think that everyones said the same thing that youve said over and over again.  Dont you think its time for something more?

Medical Forum United States | Reply

5/1/2010 4:41:41 AM #

cuisinart boiler

Double boilers include multiple measurements and capacity. The actual outer body is made of stainless steel, which will never corrode due to its exposure to high temperatures. They are also available with lids, that make sure they are convenient to handle. They enhance your kitchen and are generally rather compact and adaptable. Loads of cooking bowls are available which in turn assists with straightforward storage.

cuisinart boiler United States | Reply

5/3/2010 3:20:16 AM #

wedding anniversary gifts by year

I think youve made some truly interesting points.  Not too many people would actually think about this the way you just did.  Im really impressed that theres so much about this subject thats been uncovered and you did it so well, with so much class.  Good one you, man!  Really great stuff here.

wedding anniversary gifts by year United States | Reply

5/3/2010 5:46:54 AM #

free business cards

I dont know what to say.  This is definitely one of the better blogs Ive read.  Youre so insightful, have so much real stuff to bring to the table.  I hope that more people read this and get what I got from it:  chills.  Great job and great blog.  I cant wait to read more, keep em comin!

free business cards United States | Reply

5/29/2010 4:08:09 AM #

game downloads

Thank you so much for this!  I havent been this thrilled by a blog for a LONG time!  Youve got it, whatever that means in blogging.  HaHa.  Youre definitely someone that has something to say that people need to hear.  Keep up the great work.  Keep on inspiring the people!

game downloads United States | Reply

5/29/2010 7:45:14 PM #

guru blueprint

Ha ha. I'm impressed.

guru blueprint United States | Reply

5/30/2010 12:34:41 AM #

free shooting games

Really a delightful blogpost. Thank you very much for spreading this important info...

free shooting games United States | Reply

5/31/2010 4:16:00 AM #

designer handbags

Bulgaria Property

I like the blog, but could not find how to subscribe to receive the updates by email.

designer handbags United States | Reply

5/31/2010 1:39:42 PM #

sim date

hey pal, amazing blog post.. Pls keep them coming!!

sim date United States | Reply

5/31/2010 10:43:06 PM #

nose hair clipper

How-do-you-do, just needed you to know I have added your site to my Google bookmarks because of your extraordinary blog layout. But seriously, I think your site has one of the freshest theme I've came across. It really helps make reading your blog a lot easier.

nose hair clipper United States | Reply

6/3/2010 12:59:07 AM #

19th century rectangual chess sofa table

19th century rectangual chess sofa table

19th century rectangual chess sofa table Russia | Reply

6/3/2010 2:00:21 AM #

rugs for the home

Give me a lever long enough and a fulcrum on which to place it, and I shall move the world. Brenda

rugs for the home United States | Reply

7/10/2011 6:01:57 AM #

pingback

Pingback from fatimaaube.wordpress.com

His words of soul « fatimaaube

fatimaaube.wordpress.com | Reply

8/23/2011 1:43:33 PM #

Blackberry repair

This is one of the most incredible blogs Ive read in a very long time. The amount of information in here is stunning, like you practically wrote the book on the subject. Your blog is great for anyone who wants to understand this subject more. Great stuff; please keep it up!

Blackberry repair United States | Reply

9/7/2011 12:01:26 PM #

iPhone water damage repair

I found your blog while searching my topic and your blog completes my material thanks hope you will keep me up to date.

iPhone water damage repair United States | Reply

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading



Nurgün Özgür

Facebook

 

Nurgün Özgür Photo

1993'ten bu yana profesyonel olarak yazılım ve sistem yönetimi konularında çeşitli yerli ve yabanci kuruluşların farklı kademelerinde aktif olarak yer aldım. 2011 yılında emekliliğe ayrıldım.

 

Valid XHTML 1.0 Transitional


Tag cloud


Facebook ile giriş