Sunday, December 23, 2007

db-links.

case : scott user wantt to access objects of the sales user in same database by using dblink.(assume he has select any table privilege)


SQL> conn scott/tiger
Connected.

SQL> select * from session_privs;

PRIVILEGE
----------------------------------------
CREATE SESSION
ALTER SESSION
UNLIMITED TABLESPACE
CREATE TABLE
CREATE CLUSTER
CREATE SYNONYM
CREATE VIEW
CREATE SEQUENCE
CREATE DATABASE LINK
CREATE PROCEDURE
CREATE TRIGGER

PRIVILEGE
----------------------------------------
CREATE TYPE
CREATE OPERATOR
CREATE INDEXTYPE

14 rows selected.

SQL> create database link proddb connect to sales identified by password using 'proddblocal'
create database link proddb connect to sales identified by password using 'proddblocal'
*
ERROR at line 1:
ORA-02082: a loopback database link must have a connection qualifier
SQL> ed
Wrote file afiedt.buf
1 create database link proddb@proddb
2 connect to sales identified by password
3* using 'proddblocal'
SQL> /

Database link created.

SQL> select count(*) from dual@proddb ;

COUNT(*)
----------
1

SQL> select * from user_db_links;

DB_LINK USERNAME PASSWORD HOST

CREATED
proddb.sales.ORG@proddb sales password proddblocal

27-APR-07

SQL> conn sales/password@proddblocal
Connected.
SQL> select count(*) from tsales;

COUNT(*)
----------
246678

SQL> conn scott/tiger
Connected.
SQL> select count(*) from tsales@proddb@proddb;

COUNT(*)
----------
246678

20 comments:

prakash said...

it was very useful to me.. i need data guard like this can u..

Anonymous said...

Thіѕ piece οf writing ωill
help the internet people for creating nеw webpage oг еѵen а weblog
from staгt to еnd.
Take a look at my weblog spiele spielen

Anonymous said...

Bе intеllеctual enough to see thаt youг ad does not go
on аir οn а unseemlу ѕhow ; а Christian book
going on aіr on a show that iѕ about handling
sexual issueѕ would be riԁiсulοus.
Anothеr thing you'll need is some strength to endure, because there'ѕ a good chаncе you'll be your own producer for the show or perhaps the best producer the show has. A MOBILE APP GIVES THE STATION A DIRECT MARKETING CHANNEL TO COMMUNICATE WITH THEIR LISTENERS.

my page; radio sender

Anonymous said...

They had not yet been released for the some mobiles while these
games are well known to those that play in the regular Slots gratis mobile.
This is the Baccarat online really different, so are able to attract
players to play Posh least $ 500 a night. It features
an interesting game play and it provides benefits at every stage of
the game.

Stop by my webpage synce.org

Anonymous said...

The reason for this is muscle is build up when your physical exercise burns
your fat. Glättung des Verdauungssystems Die enthaltenen Lotusblätter sorgen für effektive Diurese,
dadurch die Eingeweide sich entspannen können. Jedoch das Schwierigkeit durch Diäten wie die Atkins Diät ist's, dass sie Sie setzen rein ernste Gefahr für Bluthochdruck und hohe Cholesterinwerte.

Feel free to surf to my web-site; http://www.largemouthpr.com/our-blog/entry/top-5-things-ive-learned-from-my-Internship.html

Anonymous said...

You can аlso buу bundle deals, which most radio stations offer,
to decreaѕe the оverall ad сost. Another thing уou'll need is some strength to endure, because there's a gooԁ
chancе уou'll be your own producer for the show or perhaps the best producer the show has. A MOBILE APP GIVES THE STATION A DIRECT MARKETING CHANNEL TO COMMUNICATE WITH THEIR LISTENERS.

Also visit my web blog :: kostenlos spielen ohne anmeldung

Anonymous said...

Eye to computer screen control is also available. So even at young ages and relatively low levels of the
sport, goalies will have their helmets designed with various colors, prints
and patterns, shapes or designs, and more. Wherever you click you are instantly
overwhelmed with special offers: book this, buy that, fly with
us, hop on this, reserve that. When it comes to bridging your skills gap
in gaming world then you can do anything to prove yourself.
In doing so, it becomes the only potential choice for best gaming PC
under 500 bucks in the desktop category. It is hard to believe that we are unable
to provide the minimum required comfort to our old ones, destitute women and even orphans.
In 2005, the QI Group acquired a UK-based independent telecommunications
provider with a strong background in providing advanced
communications solutions and technology in the United Kingdom.
In fact the publicly owned Ecopetrol has seen an immense FDI surge in the past few years and
in spite of being overvalued to some, the stock still is a good bet
due to the growth potential it has. a far cry: a long way from.
So be it.

Review my web-site ... http://tw.robotorg.com/

Anonymous said...

However, the number of apps is steadily rising, and if Nokia continues
to put out quality phones like the Lumia 900, we may see
developers take more notice and the number of apps will rise accordingly.
If you look around your community, our country, and the world, there is little evidence of
loving actions. If you have ever tried to kid yourself that everything will be fine and glossed over certain issues
because you wanted to avoid them, or did not know how to deal with them.
So, in conclusion, removing the headphones from your MP3 player is not bad, provided you don't yank too hard on the cord. Their history timeline details how the greenhouse covered 4,000 square feet, and in 1976, a 6,000 square foot greenhouse was added. Originally established as a sanctuary for the Nilgiri Tahr, the 'The Eravikulam National Park' has now turned into a highly popular tourist spot. A low quality product may lose its shine in a few days or may simply get tarnished due to overuse or after coming in contact with water. I'm the kind who smokes and judges people' Vanda pretends to demonstrate a yoga pose with a cigarette in her hand' 'Whoa, THAT guy's out of shape''.
Dependency enslaves you, giving others the ultimate power
over how you perceive and feel about yourself.
Therefore, you cannot afford to miss this incredible shooter game involving a series of killings.



Also visit my site http://iestpchocope.edu.pe/wiki/index.php?title=User:DrusillaC

Anonymous said...

You could definitely see your enthusiasm in the article you write.

The sector hopes for more passionate writers like you who are not afraid to mention how they believe.

At all times go after your heart.

Also visit my web page :: his comment is here

Anonymous said...

Undeniably belіeve that which you statеd. Үouг favогite reason aρpeaгeԁ to bе
on the internet the simрlest thing to be aware
of. I ѕay to you, I сertainly gеt annoyеd while
ρеople think about wоrriеs that they plainly don't know about. You managed to hit the nail upon the top and also defined out the whole thing without having side effect , people can take a signal. Will likely be back to get more. Thanks

Here is my web page :: Inbound Link Checker

Anonymous said...

I don't even know how I ended up here, but I thought this post was great. I do not know who you are but certainly you're going
to a famous blogger if you are not already ;)
Cheers!

my web page ... private mortgage rates Toronto

Anonymous said...

Sometimes seasons reasons some shoes might[url=http://niketrainersuksale.webeden.co.uk]Nike Trainers UK[/url]
temporarily do not possess the ability[url=http://tomscanadaoutlet.snappages.com]Toms Canada[/url]
wear such shoes excellent artwork i just[url=http://addnikecanadastore.snappages.com]Nike Shoes Online[/url]
properly put them[url=http://toplouboutinuksales.webeden.co.uk]Christian Louboutin Sale[/url]
into the[url=http://louboutintrainersuk.blog.co.uk]Christian Louboutin Sale[/url]
right insert order to avoid unnecessary harm to shoes[url=http://salelouisvuittonuk.webeden.co.uk]Louis Vuitton UK[/url]

Might be a insole is definately bad, [url=http://cheapnikeblazersuk.webeden.co.uk]Cheap Nike Blazers[/url]
it is require to use a soft brush and water gently scrub. Should really be noted that,[url=http://justlouboutintrainersuk.webeden.co.uk]Christian Louboutin Outlet[/url]
don't use chemical cleaners cleaning, or may result in the insole the top of cloth off.[url=http://shoppradabagsuk.webeden.co.uk]Prada Handbags[/url]

Anonymous said...

My partner and I absolutely love your blog
and find the majority of your post's to be what precisely I'm looking for.

can you offer guest writers to write content for you personally?
I wouldn't mind writing a post or elaborating on a number of the subjects you write regarding here. Again, awesome site!

Review my website - book of rah Kostenlos spielen

Anonymous said...

I was suggested this web site by my cousin. I'm not sure whether this post is written by him as no one else know such detailed about my problem. You're amazing!
Thanks!

Have a look at my blog book of ra kostenlos spielen ohne anmeldung

Anonymous said...

Do you have a spam problem on this website; I also am a
blogger, and I was wondering your situation; many of us have created some nice methods and we are looking to swap strategies with other
folks, why not shoot me an email if interested.

Feel free to surf to my website: novoline automaten spielen kostenlos

Anonymous said...

Just desire to say your article is as astonishing.
The clearness in your post is just great and i could assume you're an expert on this subject. Well with your permission allow me to grab your feed to keep up to date with forthcoming post. Thanks a million and please continue the rewarding work.

My webpage: a fantastic read

Unknown said...

AMAZING AND AWESOME INFORMATION !
THANKS FOR YOU!!!
Visit: Game Paling Keren 2015

Unknown said...

air jordans
burberry outlet online
michael kors outlet online
michael kors handbags
coach outlet
timberland boots
louis vuitton handbags
basketball shoes
cheap oakley sunglasses
nike store
louis vuitton handbags
michael kors outlet online
nike nfl jerseys
coach factory outlet
nike air force 1
fake watches
ed hardy clothing
tiffany jewelry
louis vuitton outlet
air jordan pas cher
cheap oakley sunglasses
jordan shoes
christian louboutin outlet
celine handbags
christian louboutin outlet
adidas shoes
oakley outlet
ray ban sunglasses outlet
louis vuitton outlet
ray ban sunglasses
coach outlet
nike air max 90
coach factory outlet
cheap toms shoes
timberland outlet
coach outlet
jordans
ralph lauren polo
coach outlet
jordan 4 toro
20166.4wengdongdong

jeje said...

pandora jewelry
prada sunglasses
kyrie irving shoes
michael kors outlet
hermes belt
retro jordans
adidas outlet online
longchamp outlet
nike huarache sale
nike air force 1 low

jeje said...

jordan retro
patriots jersey
adidas eqt
jordan 11
longchamp handbags
cheap nfl jerseys china
birkin bag
lebron 15 shoes
michael kors handbags
kate spade outlet online