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

[CORLEONE]

Row level security ane concept emaina undaa

[Jeffa]

INSERT records to database table oracle ani search kottu

[Jeffa]

[url="http://psoug.org/definition/INSERT.htm"]INSERT[/url] [url="http://psoug.org/definition/INTO.htm"]INTO[/url] <table_name>
(<column_name>)
[url="http://psoug.org/definition/VALUES.htm"]VALUES[/url]
(<value>);

table name place loo table name ichey, column name place anni columns varasa ga comma seperated, value place lo columns ki tagga values comma seperated.

integer badulu string alantivi ivvakunda chusukoo

[Kakateyudu]

[quote name='Sapota' timestamp='1325928368' post='1301254565']
grant example:

grant SELECT on <table_name> to <user>
[/quote]

aa user ki access vundha leda ani naku sambandam led mama..... na pani okkate aa user ki kanapade le data insert cheyyali and nen master user use chesi insert chesta

same tables for all

[Kakateyudu]

[quote name='RODEO' timestamp='1325928486' post='1301254575']
[url="http://psoug.org/definition/INSERT.htm"]INSERT[/url] [url="http://psoug.org/definition/INTO.htm"]INTO[/url] <table_name>
(<column_name>)
[url="http://psoug.org/definition/VALUES.htm"]VALUES[/url]
(<value>);
[/quote]


specified users ki matrame insert cheyyali baa

[Kakateyudu]

[quote name='CORLEONE' timestamp='1325928373' post='1301254566']
Row level security ane concept emaina undaa
[/quote]

alantivi em lev mama.....

basic na nadhi TIBCO process, na pani okkate master user ga na process ki access vuntadi and nen specify chesina users database lo data insert cheyyali as simple as that

[Jeffa]

[quote name='Kakateeyudu©' timestamp='1325928551' post='1301254584']


specified users ki matrame insert cheyyali baa
[/quote]

column name untundi kada baa..columns loo name ane coumn untundi kada...

daniki value aa specified userr ichey...

ante naaku sarigga ardam kaledemo..

[Sapota]

INSERT ALL
INTO tablespace.table1(COLUMN1,COL2,..) VALUES(VAL1,VAL2,..)
INTO tablespace.table2(COLUMN1,COL2,..) VALUES(VAL1,VAL2,..)
.
.
.
SELECT * FROM DUAL.

idi try cheyi baa...many tables ki single insert stmnt. not sure ni case lo ela work autundo mari.
tarvata grant command tho users ki permissions ivvali on tables.

[Kakateyudu]

[quote name='RODEO' timestamp='1325928630' post='1301254597']

column name untundi kada baa..columns loo name ane coumn untundi kada...

daniki value aa specified userr ichey...

ante naaku sarigga ardam kaledemo..
[/quote]


column lo name ane column lo user evvala ?

ardam kaledu mama.....

suppose

ABC ane dhi database mama:

indulo kaka, rodeo, sapota ane database users vunnaru.....

aa database users ki kanapadela matrame data insert cheyyali

[Kakateyudu]

[quote name='Sapota' timestamp='1325928803' post='1301254625']
INSERT ALL
INTO tablespace.table1(COLUMN1,COL2,..) VALUES(VAL1,VAL2,..)
INTO tablespace.table2(COLUMN1,COL2,..) VALUES(VAL1,VAL2,..)
.
.
.
SELECT * FROM DUAL.

idi try cheyi baa...many tables ki single insert stmnt. not sure ni case lo ela work autundo mari.
tarvata grant command tho users ki permissions ivvali on tables.
[/quote]


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]

[Jeffa]

[quote name='Kakateeyudu©' timestamp='1325928811' post='1301254627']


column lo name ane column lo user evvala ?

ardam kaledu mama.....

suppose

ABC ane dhi database mama:

indulo kaka, rodeo, sapota ane database users vunnaru.....

aa database users ki kanapadela matrame data insert cheyyali
[/quote]

aithe calling exferts...naaku teliyadu baa..row level permissions emaina untayemo oracle loo google cheyyi...only aa konni rows matrame palana users ki kanapadali ante how?

[Kakateyudu]

[quote name='RODEO' timestamp='1325929099' post='1301254670']

aithe calling exferts...naaku teliyadu baa..row level permissions emaina untayemo oracle loo google cheyyi...only aa konni rows matrame palana users ki kanapadali ante how?
[/quote]

insert into rodeo.tablename(values)

aa statement emanna vundha asalu ?

[google2011]

nuv normal ga insert chesi ... grants evachu kada neku ee users ki data kanipiyalo aa users ki grant evvu...

[Sapota]

[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]

data insert cheyalsindi into only 1 table?

[Kakateyudu]

[quote name='Sapota' timestamp='1325929298' post='1301254707']

data insert cheyalsindi into only 1 table?
[/quote]

Yah anthe mama