Ibu martina, maksud anda userA dari schema A bisa melakukan write ke table2 yang terdapat di schema B kan ? itu cara nya adalah grant select, update, delete, insert on schemaB.<nama table> to userA;
--- On Fri, 4/7/08, Lie Martina <[EMAIL PROTECTED]> wrote: From: Lie Martina <[EMAIL PROTECTED]> Subject: Re: [indo-oracle] Write access ke suatu schema tertentu To: [email protected] Date: Friday, 4 July, 2008, 3:23 PM Tulisnya ke file yang namanya bisa beda-beda, jadi belum punya nama saat ini, tergantung hasil run dari system. Semacam file buangan yang namanya acak, gitu. Thx. ----- Original Message ----- From: Yoel Susanto To: indo-oracle@ yahoogroups. com Sent: Friday, July 04, 2008 3:22 PM Subject: Re: [indo-oracle] Write access ke suatu schema tertentu Random File??? mau nulis log nya ke file atau ke table? kalo ke table Connect as owner schemaS2 Grant INSERT on <log table> to A; Itu sudah memberikan access write ke user A atas log table di schema S2. 2008/7/4 Lie Martina <[EMAIL PROTECTED] com>: > Dear all, > > User-A hanya punya akses Read ke schema S1. Bila mau nulis error log > (random file), bisa tidak User-A nulisnya di schema S2? > Bagaimana syntax memberikan hak tulis User-A ke schema S2? > (Schema S1 dan S2 ada pada instance yang sama). > Thx. > > ----- Original Message ----- > From: hendra chen > To: indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com> > Sent: Friday, July 04, 2008 2:47 PM > Subject: Re: [indo-oracle] Write access ke suatu schema tertentu > > buat user nya di schema penampung nya, trus grant ke schema yang hanya mau > di baca. > > --- On Fri, 4/7/08, Yoel Susanto <yoel.susanto@ gmail.com<yoel.susanto% 40gmail.com> > > wrote: > From: Yoel Susanto <yoel.susanto@ gmail.com <yoel.susanto% 40gmail.com> > > Subject: Re: [indo-oracle] Write access ke suatu schema tertentu > To: indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com> > Date: Friday, 4 July, 2008, 2:26 PM > > > Sorry, rada membingungkan penjelasannya. > > bisa lebih jelas lagi gak? > > user A punya error mau di log ke table di User B...begitu? > > 2008/7/4 Lie Martina <[EMAIL PROTECTED] tires. com>: > > > Dear all, > > > > > > Mau tanya dong..... > > > Kita punya satu user User-A pada instance Instance-A dengan akses Read, > di > > > mana kita perlu menampung semacam error log yang dihasilkan oleh system > pada > > > saat running, dengan nama table yang tidak pasti (dirandom oleh system). > > > Rencananya error-error log ini kita alihkan pada satu schema tertentu > yang > > > memiliki akses Write. Bagaimana ya caranya kita meng-assign User-A ke > schema > > > penampungan ini, sehingga dia bisa Write di schema tersebut, tetapi tetap > > > hanya bisa Read saja ke schema yang lain. > > > Thanks buanget ..... > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > -- > > Cheers, > > Yoel Susanto > > www.indo-oracletech .com > > [Non-text portions of this message have been removed] > > New Email addresses available on Yahoo! > Get the Email name you've always wanted on the new @ymail and > @rocketmail. > Hurry before someone else does! > http://mail. promotions. yahoo.com/ newdomains/ sg/ > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > > -- Cheers, Yoel Susanto www.indo-oracletech .com [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] New Email names for you! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does! http://mail.promotions.yahoo.com/newdomains/sg/ [Non-text portions of this message have been removed]
