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

[Kakateyudu]

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

[baluabcdefgh]

[Kakateyudu]

[quote name='SILENT KILLER' timestamp='1325926968' post='1301254330']

[/quote]

Help pls thanks

[D.V.S.KARNA]

[baluabcdefgh]

[quote name='Kakateeyudu©' timestamp='1325926993' post='1301254336']

Help pls thanks
[/quote]
naaku oracle raadu ga google chesaava

[Nadimitla Abbulu]

calling acp

[dkchinnari]

help... acp help

[Kakateyudu]

[quote name='SILENT KILLER' timestamp='1325927076' post='1301254349']
naaku oracle raadu ga google chesaava
[/quote]

emani cheyyalo kuda seppu

[Kakateyudu]

[quote name='CheemaChitikenaVelu' timestamp='1325927079' post='1301254350']
calling acp
[/quote]

thanks baa calling ACP

[baluabcdefgh]

[quote name='Kakateeyudu©' timestamp='1325927123' post='1301254363']

emani cheyyalo kuda seppu
[/quote]adhi telisthe eee paatiki cheppevaadini kada

[Kakateyudu]

Denemma ammai thedd este matram ee time ki 10 pages velledemo

[Sapota]

rows ki permissions set cheyalemu. tables ke set chestamu.
so nuvvu first insert execute chesi then aa tables ki grants set cheyali.
nuvvu ide strategy expect chestunte cheppu..same table for all users/different tables aa? default tablespace aa adi for all users/unique tablespaces aa kuda teliyali aa statement rayali ante..

[Achilles_afdb]

help

[Kakateyudu]

[quote name='Sapota' timestamp='1325928156' post='1301254545']
rows ki permissions set cheyalemu. tables ke set chestamu.
so nuvvu first insert execute chesi then aa tables ki grants set cheyali.
nuvvu ide strategy expect chestunte cheppu..same table for all users/different tables aa? default tablespace aa adi for all users/unique tablespaces aa kuda teliyali aa statement rayali ante..
[/quote]


Same tables baa andariki........ simple ba na requirement tables lo data insert cheyyali and specified users ki

yah default table space ye mama andariki same tables

[Sapota]

grant example:

grant SELECT on <table_name> to <user>