| Author |
Message |
    
310
Kurra Bewarse
Username: 310
Post Number: 706
Registered: 12-2006
Posted From: 24.117.150.246
Rating: N/A
Votes: 0 (Vote!) | | Posted on Saturday, July 11, 2009 - 8:46 pm: |
|
DB link undi antunnav inka nevu access yela isthav asala ... synonym create chesukovali adi kudaaa aa DB link meeda access undali migatha users ki chala thathangam undi |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 11080
Registered: 06-2004
Posted From: 75.138.195.125
Rating: N/A
Votes: 0 (Vote!) | | Posted on Saturday, July 11, 2009 - 8:38 pm: |
|
310:hemesh baaa
select * from owner.tablename anali eppudainaaaa
ade anna baa..still work avvaledu... |
310
Kurra Bewarse
Username: 310
Post Number: 701
Registered: 12-2006
Posted From: 24.117.150.246
Rating: N/A
Votes: 0 (Vote!) | | Posted on Saturday, July 11, 2009 - 8:12 pm: |
|
hemesh baaa
select * from owner.tablename anali eppudainaaaa |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 11079
Registered: 06-2004
Posted From: 75.138.195.125
Rating: N/A
Votes: 0 (Vote!) | | Posted on Saturday, July 11, 2009 - 8:11 pm: |
|
hmm..inka chirakochesi same user dantlo..table create chesi load chesi padesaa..report generate chesaka table data delete chesa..lekapothe audit vallu kummestharu..sensitive info undi..kiki |
310
Kurra Bewarse
Username: 310
Post Number: 700
Registered: 12-2006
Posted From: 24.117.150.246
Rating: N/A
Votes: 0 (Vote!) | | Posted on Saturday, July 11, 2009 - 8:10 pm: |
|
1. select * from ownerschema.tablename .. appudu access avuthadi..
1. else create a public synonym logged in as owner schema
create or replace public synonym <tablename> for <ownerschema.tablename>.... you can access the table from any other schema that has got select access to the table without qualifying the table with owner
2. if you dont want to creat public synonym, then create local synonym in the schema that you want to access the table from..
create synonym <tablename> for <ownername.tablename> |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 62863
Registered: 07-2004
Posted From: 24.229.138.244
Rating: N/A
Votes: 0 (Vote!) | | Posted on Saturday, July 11, 2009 - 7:35 pm: |
|
table ki synonym declare cheyyaalemo soodu hemesh....same schemalo login ayithe synonym akkarledhi..but multiple schemas unnattaithe cheyyaaali....
Gosi gaadu seppina maate malli seppadu,anduke signature ettadu 
|
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 11077
Registered: 06-2004
Posted From: 75.138.195.125
Rating: N/A
Votes: 0 (Vote!) | | Posted on Saturday, July 11, 2009 - 5:44 pm: |
|
oka table ni oka userid tho access chestham...aa table ki vere id ki select access ichanu..ayina sare access vellatam ledu..
like table1 is in schema(useraccess tande)
grant access on table1 to user apps with grant option;
ani ichanu..
ippudu nenu toad lo apps id tho login ayi select * from table1@dblink_tande
ani isthunna..table not found antundi..kani aa table meeda apps lo unnappudu desc kodithe details isthundi...ela ivvali grant access? |
Archives - 2009