@@@@calling Oracle Experts, Help Fleezzz @@@@

[Kakateyudu]

[quote name='google2011' timestamp='1325929284' post='1301254705']
nuv normal ga insert chesi ... grants evachu kada neku ee users ki data kanipiyalo aa users ki grant evvu...
[/quote]


aa grants anni ichese vuntai.........

basic ga na process ki oka message vastadi...... aa message parse chesi valla tables lo insert cheyyali data......

ye ye users ki insert cheyyalo na process ki vastai details

[Sapota]

[quote name='Kakateeyudu©' timestamp='1325929336' post='1301254717']

Yah anthe mama
[/quote]

next quote lo qry estana 2 mins

[Kakateyudu]

[quote name='Sapota' timestamp='1325929516' post='1301254756']

next quote lo qry estana 2 mins
[/quote]


u rock baaaaaaaaaaaaaaaaa

[baluabcdefgh]

[quote name='Kakateeyudu©' timestamp='1325928951' post='1301254648']


users ki already aa tables meda permissions vuntai mama........

see below:

[color=#282828][font=helvetica, arial, sans-serif]ABC ane dhi database mama:[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]indulo kaka, rodeo, sapota ane database users vunnaru.....[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]aa database users ki data insert cheyyali, permissions vuntai aa tables ki vallaki[/font][/color]
[/quote]
aaa tables meedha permission vunappudu nuvvu aa database lo data insetr tcheste vallu choosukuntaaru kada ante vere users kooda vunnaara database vallu kaaka and moreover tables ki access vundadhu kada okavela vunte aaa users ki grant select on tablename to use rani ivvu

[Kakateyudu]

[quote name='SILENT KILLER' timestamp='1325929546' post='1301254764']
aaa tables meedha permission vunappudu nuvvu aa database lo data insetr tcheste vallu choosukuntaaru kada ante vere users kooda vunnaara database vallu kaaka and moreover tables ki access vundadhu kada okavela vunte aaa users ki grant select on tablename to use rani ivvu
[/quote]


nen database admin ni kadhu ra ayya.......

[color=#282828][font=helvetica, arial, sans-serif]basic ga na process ki oka message vastadi...... aa message parse chesi valla tables lo insert cheyyali data......[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]ye ye users ki insert cheyyalo na process ki vastai details... aa users ki permissions already grant chese vuntai.... [/font][/color]

[Sapota]

INSERT ALL
INTO SAPOTA.TABLENAME(COL1,COL2....) VALUES(VAL1,VAL2,VAL3)
INTO RODEO.TABLENAME(COL1,COL2....) VALUES(VAL1,VAL2,VAL3)
.
.
INTO KAKA.TABLENAME(COL1,COL2....) VALUES(VAL1,VAL2,VAL3)
SELECT * FROM DUAL;

sapota.fruit ante sapota schema lo fruit table. every user has its own schema. this should work..ippude try chesi cheppagalgutava? work avaka pote inkoka way lo cheyachu anukunta..

[Sapota]

[quote name='Sapota' timestamp='1325929776' post='1301254813']
INSERT ALL
INTO SAPOTA.TABLENAME(COL1,COL2....) VALUES(VAL1,VAL2,VAL3)
INTO RODEO.TABLENAME(COL1,COL2....) VALUES(VAL1,VAL2,VAL3)
.
.
INTO KAKA.TABLENAME(COL1,COL2....) VALUES(VAL1,VAL2,VAL3)
SELECT * FROM DUAL;

sapota.fruit ante sapota schema lo fruit table. every user has its own schema. this should work..ippude try chesi cheppagalgutava? work avaka pote inkoka way lo cheyachu anukunta..
[/quote]

this works baa...grant avasaram ledu inka..ikkada maa friend ki kuda chupincha..try it good luck..

[baluabcdefgh]

[quote name='Kakateeyudu©' timestamp='1325929692' post='1301254789']


nen database admin ni kadhu ra ayya.......

[color=#282828][font=helvetica, arial, sans-serif]basic ga na process ki oka message vastadi...... aa message parse chesi valla tables lo insert cheyyali data......[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]ye ye users ki insert cheyyalo na process ki vastai details... aa users ki permissions already grant chese vuntai.... [/font][/color]
[/quote]
avuna nenu jumf ala aithe nenu aithe ilaane sestha neeku naa laaga anni permissions vuntaayui anukunna

[Kakateyudu]

[quote name='Sapota' timestamp='1325929776' post='1301254813']
INSERT ALL
INTO SAPOTA.TABLENAME(COL1,COL2....) VALUES(VAL1,VAL2,VAL3)
INTO RODEO.TABLENAME(COL1,COL2....) VALUES(VAL1,VAL2,VAL3)
.
.
INTO KAKA.TABLENAME(COL1,COL2....) VALUES(VAL1,VAL2,VAL3)
SELECT * FROM DUAL;

sapota.fruit ante sapota schema lo fruit table. every user has its own schema. this should work..ippude try chesi cheppagalgutava? work avaka pote inkoka way lo cheyachu anukunta..
[/quote]

i guess this should work mama....... na daggara database ledu eppudu, requirement mama idhi....

i guess this should work......

ela chetse aa database lo vunna vere users ki data kanapadutundha leda ?

[Kakateyudu]

[quote name='SILENT KILLER' timestamp='1325929928' post='1301254841']
avuna nenu jumf ala aithe nenu aithe ilaane sestha neeku naa laaga anni permissions vuntaayui anukunna
[/quote]

already ichesi vuntai permissions adhi admins pani.... permission evvakunda insert cheyyamani sepparu kada

[Kakateyudu]

[quote name='Sapota' timestamp='1325929840' post='1301254826']

this works baa...grant avasaram ledu inka..ikkada maa friend ki kuda chupincha..try it good luck..
[/quote]


yah even i guess this should work....... thanks a truck load mama.....

u rockkkkkkkkkkkkkkkkkkkkk

[Sapota]

[quote name='Kakateeyudu©' timestamp='1325929956' post='1301254849']

i guess this should work mama....... na daggara database ledu eppudu, requirement mama idhi....

i guess this should work......

ela chetse aa database lo vunna vere users ki data kanapadutundha leda ?
[/quote]

it depends on roles and permissions. vere vallaki aa tables kanapadakudadu ante..
[color=#2E5348][font=Arial, Helvetica, sans-serif][size=3][b]revoke all on sapota.fruit from public;[/b][/size][/font][/color]
[color=#2E5348][font=Arial, Helvetica, sans-serif][size=3][b]grant all on sapota.fruit to sapota;[/b][/size][/font][/color]

[Kakateyudu]

[quote name='Sapota' timestamp='1325930313' post='1301254930']

it depends on roles and permissions. vere vallaki aa tables kanapadakudadu ante..
[color=#2E5348][font=Arial, Helvetica, sans-serif][size=3][b]revoke all on sapota.fruit from public;[/b][/size][/font][/color]
[color=#2E5348][font=Arial, Helvetica, sans-serif][size=3][b]grant all on sapota.fruit to sapota;[/b][/size][/font][/color]
[/quote]

select * from dual anedhi nduku use chestar mama ?

[Sapota]

[quote name='Kakateeyudu©' timestamp='1325930734' post='1301255015']

select * from dual anedhi nduku use chestar mama ?
[/quote]

dummy table lantidi adi oracle lo.

saradaga select 1+2+3+4+5+6 from dual ani chudu. sum vastadi
insert all syntax requires using select. select output cols tho insert col values set cheyachu. ikkada manaki aa avasaram ledu kabatti pseudo ga select * from dual ani pettam.

ni fost ippude chusa ba..

[vijay2349]

[quote name='Kakateeyudu©' timestamp='1325926873' post='1301254305']
Oka database vundhi, and it has many users.....

so nenu master user ga login avta and then i need to insert a few rows into some user databases, such that only those users can see that data..

aa statements examples konchem ela vuntai oo seppandi baa.....

insert into user.tablename values (.............) ala edo vuntundhi kada format.....

Help fleezzzzzzzzz


[/quote]

www.google.com