berarti tulis ke external file...kalo access ke file tidak di miliki oleh schema tertentu (untuk kasus anda schema S2). akan tetapi akses ke oracle directory tempat file tersebut berada.
langkah2: 1. Create directory di file system for e.g /oracle/logfiles 2. create directory di oracle create directory LOGFILE as '/oracle/logfiles' 3. grant read,write on directory logfile to A 4. terus bikin procedure error_logging yang akan tulis ke file tersebut. 2008/7/4 Lie Martina <[EMAIL PROTECTED]>: > 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: [email protected] <indo-oracle%40yahoogroups.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] <martina%40gt-tires.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: [email protected] <indo-oracle%40yahoogroups.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 <[EMAIL > > PROTECTED]<yoel.susanto%40gmail.com> > <yoel.susanto%40gmail.com>> > > wrote: > > From: Yoel Susanto <[EMAIL PROTECTED] > > <yoel.susanto%40gmail.com><yoel.susanto% > 40gmail.com>> > > Subject: Re: [indo-oracle] Write access ke suatu schema tertentu > > To: [email protected] <indo-oracle%40yahoogroups.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] 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] > > > -- Cheers, Yoel Susanto www.indo-oracletech.com [Non-text portions of this message have been removed]
