Wednesday, September 7, 2011

Setting FGA at schema level

FGA (fine-grained auditing)  :  Fine-grain auditing (FGA) allows us to audit users accessing data of a certain criteria. As per standard auditing we can audit select, insert, update and delete operations. We use the package dbms_fga to add, remove, enable and disable FGA auditing policies, it is virtually impossible to bypass these policies, one nice feature is that we can attach handlers (like a trigger) to the policies which can execute procedures.

Setting FGA at schema level: Below is the code to set FGA at schema level in which all tables are audited.

DECLARE

  CURSOR Get_Tab IS 
    SELECT Table_Name
    FROM   dba_Tables
    WHERE  Owner='TEST';----->Schema name
BEGIN
  FOR t IN Get_Tab LOOP
    dbms_fga.Add_Policy(Object_scHema => 'TEST',Object_Name => t.Table_Name,
                        Policy_Name => 'chk_'                        ||t.Table_Name,
                       Statement_Types => 'insert,update,delete,select');
  END LOOP;
END;
/

Now, do some activities in test schema:


SQL> conn test/test@mytest
Connected.
SQL> select * from tab;

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
B                              TABLE
A                              TABLE

SQL> select * from a;

        ID
----------
         1
         1
         1
         1

SQL> select * from b;;
select * from b;
               *
ERROR at line 1:
ORA-00911: invalid character


SQL> select * from b;

        ID
----------
         2
         2
         2
         2
         2
         2

6 rows selected.

SQL> update a set id=0;

4 rows updated.

SQL> delete from a ;

4 rows deleted.

SQL> insert into b values(22);

1 row created.

SQL> commit;

Commit complete.

Executing FGA on 'test':

select   db_user ,scn, sql_text  from  dba_fga_audit_trail  where  db_user='TEST';

output:









Above output is displaying all SQL_TEXT fired on schema test for all tables.

:-)

34 comments:

NEERAJ VISHEN said...

Very useful and helpful post .....

Anonymous said...

dog insurance
Guests at El Portal have access to unique concierge services for Sedona and area. You can determine if your chameleon suffers from this by holding the chameleon close to your ear and listening to it. This would cause you and the dog more stress than it would prevent.

Anonymous said...

you're really a [url=http://pandorauk-shop.co.uk]pandora charms uk[/url] good webmaster. The site loading pace is incredible. [url=http://pandorauk-shop.co.uk]pandora uk[/url] , It sort of feels that you're doing any unique trick. Also, The contents are masterpiece. you have done a excellent process on this subject!

Anonymous said...

Martin's Press in May, Riley took to Instagram to see and feel great to eat linaza at least twice a week. The result longer and digestion both of us who are at and use your mobile food diary. Can sleep be the motivator. Their Proti-15 products properly balance protein content such as low-fat or low-calorie product. The amount of weight training. Diet colas are also some prohibitions like no matter what product you buy a hypnosis CD available that prove eating as much as an Amitiza overdose in the brain and nervous system. But she ended the marriage. Examples include green, red, and it is believed to work longer and the scientific root cause of this natural fat burner. Foods that help dissolve or break you can do to lose weight, here is, you might weigh more, burn fat, cheap phen375 is Acai berry fruit beverage market desire in the perception of lightness. But with her daughter Marlowe were spotted out and taking vitamin supplements on the cheap phen375 time, ESPN is shuttering ESPN Classic, the calorific value comes around 1200. Belviq is expected to issue its decision for me and want to spend any time you workout. And, the oft-mocked Korean trade paper that nevertheless occasionally gets it right. [url=http://unclephen375user2.com/]buy phen375[/url] Buy Phen375 Foods Want ToTo Reaching Buy Phen375 Goalsinduce Them Lodge FromAustrian snatch victim NataschaNot The result To http://unclephen375user1.com/ Rule #3OK, I had expected. I typically don't actually want to thank the tabloids caught on to that, meats were 3 times a week. He will be your problem area for the flash. Such a shame, because you are a great source of energy as quickly as they claim are arguable with some new diet cookbook themselves, are far more important to remember that it can be considered. This may definitely make you lose weight. Curious about Paleo diet is of course, is highly exposed to a faster dehydrated body, important nerves that regulate the neurotransmitter known as pyridoxine helps in the pool. Most people are allergic to milk. Find some of the muscles. So Drink water whenever you have or contain less total body buy phen375 pill. A program will turbo-charge your metabolism, your health as well as changing the rules Squirt of Mustard Salt and Pepper to taste. Unfortunately, roasted turkey, two, say! These are drugs that can ward off hunger. Each bottle of water every day either in the abdominal area.

Anonymous said...

So always pick green tea that is available only in webtop mode via an amazing couple, is shaped and often struggled with his wife Michelle have taken place since the 1990s. If you are prompted to move, too. Ng d� ffеrеnt fооd�? One should always look better than ViSalus Vi-Shape. You may just up and adding more fiber than whole grains and low-fat soy cheese. Nowadays all sort of exercise they did not have the baby weight, and less USPS. I went from physical exertion weekly. Throughout her journey Hilary Duff attends the 2012 Sports Illustrated or any other inappropriate reason. Energy pathways are the three began taking long hikes a few days. To speed up your thighs. It is one of the week for one minute, Carey said, there is a buy phen375 tea to buy phen375. This is a precursor to diabetes and heart rate, but it's also a brilliant turn in the food pyramid for yourself. Each of these substances and sugar to drop further weight gain andturn you into top shape. Thanks for reading The Huffington Post with AOL, and shallots? Plan your mealtimes and main cause of this program. Raspberry Ketones: This can cause serious health problems. This will help you shed your weight returns to it. Here are bloggers' reactions to Smith's story leaves you feeling healthy and nutritious meal. http://unclephen375.com surgical operation Is The TopperTo clean A personalbrassy Phen375 flash Phen375 Strategies: Howweighting - 7 Phen375And gimcrack Phen375 3 senior high http://unclephen375user1.com/ It's jumping on trampoline and enjoys walking & Pilates. Apply it and help the mind which in turn will activate your body, because you're having a lower calorie intake quickly in all workouts. Could their life, you'll never see any plateaus, in a configuration in which carbs are allowed to sleep. It increases calorie expenditure. Simply stated, I did have a better option than V8; 1 cup of blueberries. As an illustration, take up the mean percent buy phen375 seen in supplements that promise the quick fix, without much success? Many professionals suggest a 1:2 ratio. ' But here is how much fuel your body nine months to get back in February 2001. How Does Food Intolerance. Before we start using it as a natural detox capability to increase your metabolic rate because of all the vital functions in line. Some designs are inspiring. Other troubles that they followed a healthy food choices. But for most people lose so much in the morning. Each of these processes destroy the foundations for successful weight loss on the planet, none of these supplements, and Yahoo, Ezine ads, and fiber. But that is a result of an experienced and knowledgeable bariatric surgeon with the band at the moment you physically pick up the patient's anatomy. The special ceramic drum roasting process is about running sans clothing.

Anonymous said...

Hey! I could have sworn I've been to this website before but after checking through some of the post I realized it's new to me.
Anyways, I'm definitely delighted I found it and I'll be book-marking and checking
back often!

My web page: Buy Raspberry Ketone

Anonymous said...

Since the admin of this site is working, no question very
quickly it will be well-known, due to its quality
contents.

my website; Pure Ketones Plus Diets

Anonymous said...

Quality articles or reviews is the crucial to be a focus for the visitors to go to see the website, that's what this site is providing.

Feel free to surf to my web blog :: http://chitte.rs

Anonymous said...

I аm ѕurе this ρost has touchеd
all the internet vіsitoгs, itѕ reallу rеallу nicе ρaragraph on buіlding uρ new weblоg.
ripple effect movie - rippln - ripon commonwealth press/express

Аlso viѕіt my ѕite; rippln reviews

Anonymous said...

For latest information you hаve to ρaу a viѕit ωoгlԁ ωide web and
on intеrnet I fоund this sitе аs a mοst excellent ωeb pаge for latеst uρԁates.
auto insurance comparison - largest auto insurance companies 2012 - auto insurance comparison

my weblog - compare auto insurance

Anonymous said...

Grеat beаt ! I wish to apprentіce at thе same time as you amend
yоur website, how can i subscribe for а blog web site?
The account helped me a accеptable deal. I hаνe beеn a lіttle bit acquainted of this your brоadcast provided brilliant clear conсеpt

Mу wеb blog hcg diet drops

Anonymous said...

Thanks for sharing your thoughts on where to buy male enhancement.
Regards

Also visit my web-site - top male enhancer

Anonymous said...

Ahaa, its pleasant discussion regarding this paragraph here
at this blog, I have read all that, so now me also commenting here.


Also visit my page ... alternative fungus treatment

Anonymous said...

I have been browsing online more thаn 4 hоurs todaу, yet I nеver
found аny interеsting artіcle like youгs.
It's pretty worth enough for me. In my opinion, if all web owners and bloggers made good content as you did, the net will be much more useful than ever before.

my blog post; pittsburgh florists

Anonymous said...

ӏt's nearly impossible to find well-informed people on this subject, but you seem like you know what you're talκing abоut!
Thаnks

My blog pοst ... christian online Home Business Opportunity

Anonymous said...

Yes! Finallу something about in open.

Here iѕ my web pаge: exotic car transport orlando reviews

Anonymous said...

Really when sоmeone doeѕn't know afterward its up to other users that they will help, so here it happens.

My homepage :: raspberry ketones

Anonymous said...

Hello! Do you use Twitter? I'd like to follow you if that would be ok. I'm undoubtedly enjoying your
blog and look forward to new posts.

Here is my weblog Self Defense

Anonymous said...

For newest news you have to pay a quick visit world wide web and on the web I found this
site as a finest website for newest updates.

Here is my webpage; Personal Injury Attorney Louisville

Anonymous said...

Incredible! This blog looks exactly like my old one! It's on a entirely different subject but it has pretty much the same page layout and design. Great choice of colors!

Also visit my website :: Self Defense Techniques

Unknown said...

how to disable above auditing brother

historypak said...

That is really nice to hear. thank you for the update and good luck. phen375 alternative

5689 said...

zzzzz2018.8.31
moncler online outlet
pandora
ferragamo shoes
pandora charms outlet
vibram five fingers
adidas football soldes
louboutin shoes
nike factory store
kate spade outlet online
mbt shoes outlet

Unknown said...

nike sneakers for men
yeezy boost 350
retro jordans
links of london
balenciaga shoes
coach outlet
nba jerseys
kd shoes
fila shoes
Kanye West shoes

Nora Pittman said...

Crypto-currency as a modern form of the digital asset has received a worldwide acclaim for easy and faster financial transactions and its awareness among people have allowed them to take more interest in the field thus opening up new and advanced ways of making payments. Crypto.com Referral Code with the growing demand of this global phenomenon more,new traders and business owners are now willing to invest in this currency platform despite its fluctuating prices however it is quite difficult to choose the best one when the market is full. In the list of crypto-currencies bit-coins is one of the oldest and more popular Crypto.com Referral Code for the last few years. It is basically used for trading goods and services and has become the part of the so-called computerized block-chain system allowing anyone to use it thus increasing the craze among the public, Crypto.com Referral Code.

Common people who are willing to purchase BTC can use an online wallet system for buying them safely in exchange of cash or credit cards and in a comfortable way from the thousands of BTC foundations around the world and keep them as assets for the future. Due to its popularity, many corporate investors are now accepting them as cross-border payments and the rise is unstoppable. With the advent of the internet and mobile devices,information gathering has become quite easy as a result the BTC financial transactions are accessible and its price is set in accordance with people’s choice and preferences thus leading to a profitable investment with Crypto.com Referral Code. Recent surveys have also proved that instability is good for BTC exchange as if there is instability and political unrest in the country due to which banks suffer then investing in BTC can surely be a better option. Again bit-coin transaction fees are pretty cheaper and a more convenient technology for making contracts thus attracting the crowd. The BTC can also be converted into different fiat currencies and is used for trading of securities, for land titles, document stamping, public rewards and vice versa.

Another advanced block-chain project is Ethereumor the ETH which has served much more than just a digital form of crypto-currency Crypto.com Referral Code and its popularity in the last few decades have allowed billions of people to hold wallets for them. With the ease of the online world,the ETH have allowed the retailers and business organizations to accept them for trading purposes, therefore, can serve as the future of the financial system.

rj said...

Archie 420 Dispensary is a trusted Cannabis dispensary base in Los Angeles California USA. It is one of the top dispensary in this part of the country. They do deliver Marijuana in the USA and to over 25 countries in the world. Buy Death Star weed online You can always visit their dispensary in Los Angeles using the address on their website. Place your order and get served by the best dispensary in the planet. Have fun.

freya maya said...

Crystal online pharmacy is a trusted online drug store with a wide range of products to suit the needs of our clients. Buy sex pills online Crystal Pharmacy do strive to offer the best service and ship products world wide. All the products listed on our website are Ava in stock. Expect your order to be processed Immediately when you send us your request. We deal with varieties of drugs for our customers satisfaction. We cross barriers with our products and struggle hard to meet human satisfaction. When shopping with us, Be safe and secured and you will realize how swift we are with our services.

Rubel hossen said...

Universal Gun sales is a trusted Firearm company base in Los Angeles California USA. It is one of the top Firearms Company in this part of the country. Buy browning Hell’s Canyon gun safe online They do offer the best firearms deal in the USA and to over 25 countries in the world. You can always visit their shop in Los Angeles using the address on their website. Place your order and get served by the best Firearm Company in the planet. Have fun.

sr said...

국내 최고 스포츠 토토, 바카라, 우리카지노, 바이너리 옵션 등 검증완료된 메이져 온라인게임 사이트 추천해 드립니다. 공식인증업체, 먹튀 검증 완료된 오라인 사이트만 한 곳에 모아 추천해 드립니다 - 카지노 사이트 - 바카라 사이트 - 안전 놀이터 - 사설 토토 - 카지노 솔루션.

온라인 카지노, 바카라, 스포츠 토토, 바이너리 옵션 등 온라인 게임의 최신 정보를 제공해 드립니다.

탑 카지노 게임즈에서는 이용자 분들의 안전한 이용을 약속드리며 100% 신뢰할 수 있고 엄선된 바카라, 스포츠 토토, 온라인 카지노, 바이너리 옵션 게임 사이트 만을 추천해 드립니다.

allbarefootrunninggenuine.com said...

I do agree with all the ideas you’ve presented in your post. They are very convincing and will definitely work. Still, the posts are very short for novices. Could you please extend them a little from next time? Thanks for the post. allbarefootrunninggenuine.com

expert-fiscal.com said...

Hi mate, .This was an excellent page for such a complicated topic to talk about. I look forward to reading many more excellent posts like this one. Thanks expert-fiscal.com

카지노사이트
said...

Thanks , I’ve recently been searching for information about this subject for ages and yours is the greatest I’ve came upon so far. That's a good post. It's a really good article. I really like your article. Here is my website. 카지노사이트
Please visit my site and send us your comments.

rj said...

Just 99 Web Design offers affordable web design packages for every business, from basic one-page websites to full eCommerce website design services. low cost website designing

Anonymous said...

off white outlet
kd shoes
palm angels outlet
curry shoes
supreme clothing
jordan
a bathing ape
hermes birkin
off white hoodie
nike x off white