Apakah bisa, jika kita menginginkan agar PB sama sekali tidak mencoba men-create file-file temporary tersebut siapapun usernya dan ketika pertama kali connect ke database tersebut? Satu hal yang pasti adalah connect menggunakan user id yang tidak punya akses untuk create table.
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, April 10, 2007 4:55 PM To: Mulyono Subject: Re[2]: [indopb] Table temporary Hello Mulyono, Untuk user yang sama, table-table tersebut hanya akan tercreate ketika pertama kali database dikonek dari PB, agar ketika koneksi pakai user lain tidak bikin lagi table-table tersebut, coba di properties DB Profile tabpage System, untuk PB Catalog table owner dikasih user yang sudah pernah create table-table tersebut. Semoga membantu. Tapi ingat, pertama kali koneksi dari PB ke database tersebut harus dilakukan menggunakan user yang mempunyai hak untuk create table. Tuesday, April 10, 2007, 2:47:10 PM, you wrote: ygrp_text > Maksudnya adalah tamporary table sebagai berikut: pbcatcol pbcatedt pbcatfmt pbcattbl pbcatvld PB selalu mencoba mencreate table tersebut diatas ke semua database yang di akses melaui PB development tools. Bisa nggak yach di set agar PB tidak mencreate file tersebut? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of riky andrian Sent: Tuesday, April 10, 2007 12:55 PM To: [EMAIL PROTECTED] Subject: RE: [indopb] Table temporary databasenya menggunakan apa? kalau mssql; temporary table di database TEMPDB maksudnya? bukankah hal itu adalah management DBMS mssql yang mengatur hal tersebut, untuk keperluan cache RIKY ANDRIAN IT - SRIKANDI GROUP ____________-_________-_________-__ 7th Successive 2007 Dakar Rally Victory for MITSUBISHI From 2001 With PAJERO EVOLUTION MPR13 12th Dakar Rally Victory for MITSUBISHI From 1982 ____________-_________-_________-__ From: [EMAIL PROTECTED] <mailto:indopb%40yahoogroups.com> -com [mailto: [EMAIL PROTECTED] <mailto:indopb%40yahoogroups.com> -com] On Behalf Of Mulyono Sent: Tuesday, April 10, 2007 12:39 PM To: [EMAIL PROTECTED] <mailto:indopb%40yahoogroups.com> -com Subject: [indopb] Table temporary Dear IndoPbers, Setiap kita connect ke sebuah database menggunakan PB. PB selalu berusaha untuk membuat temporary table ke database tersebut. Apakah ada setting yang bisa digunakan agar PB tidak membuat temporary tables tersebut? rgds Mulyono IMPORTANT NOTICE: The information in this email (and any attachments) is confidential. If you are not the intended recipient, you must not use or disseminate the information. If you have received this email in error, please immediately notify me by "Reply" command and permanently delete the original and any copies or printouts thereof. Although this email and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by American International Group, Inc. or its subsidiaries or affiliates either jointly or severally, for any loss or damage arising in any way from its use. -- Best regards, abraar mailto:abraar. <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] IMPORTANT NOTICE: The information in this email (and any attachments) is confidential. If you are not the intended recipient, you must not use or disseminate the information. If you have received this email in error, please immediately notify me by "Reply" command and permanently delete the original and any copies or printouts thereof. Although this email and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by American International Group, Inc. or its subsidiaries or affiliates either jointly or severally, for any loss or damage arising in any way from its use.
