Buat Pak Unang, Sekedar kelarifikais saja.. Di dalam oracle itu schema ada dalam DataBase. Jadi satu DataBAse bisa punya 1 atau lebih schema.
Salam Awonk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Unang Zulkarnain Sent: Monday, May 17, 2010 11:02 PM To: [email protected] Subject: Re: [indo-oracle] create user Dear Mas Moezahar, Setahu saya, di oracle satu user adalah satu scheme, bisa diartikan ketika membuat user amir maka langsung dibuatkan satu database amir, jadi membuat 2 user berarti membuat 2 database. Beda hal nya ketika kita bermain di Postgres atau Mysql. Untuk komunikasi antar user, bisa menggunakan dblink Semoga bisa membantu. 2010/5/17 Mustajab Moezahar <[email protected]> > > > Dear Masters Oracle, > > mohon bantuan.. bagaimana cara buat user di oracle, hanya utk table dia > saja > misalnya saya buat User asep, dia membuat table data_karyawan > lalu satu lagi saya buat user amir, dia membuat table data_gaji.. > > yg saya tanyakan bagaimana cara supaya user amir tidak bisa membukan user > asep, begitu sebaliknya.. > > asep query > select * from data_karyawan ( bisa krn table sendiri) > > User amir query > select * from data_karyawan ( tdk bisa ) tapi klo di depannya sy pakai > asep. baru bisa > select * from asep.data_karyawan (bisa), saya maunya amir tdk bisa buka > bagaimana caranya > > terimakasih > Mustajab > > [Non-text portions of this message have been removed] > > > -- Unang Zulkarnain [email protected] http://www.uzonline.co.cc [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links Unless specifically stated, any views or opinions expressed in this e-mail are those of the author only and does not constitute a formal view and/or opinion of PT. UNION SAMPOERNA TRIPUTRA PERSADA. All information and attachment in this e-mail is or may be confidential, legally privileged, and proprietary in nature or otherwise protected by law from disclosure and is intended solely for the use of the addressee(s). If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, distribution, copying or use of any part of this e-mail is strictly prohibited and unlawful, and you shall therefore notify the sender immediately and delete the e-mail from your computer.
