bisa, kan ada pengaturan hak akses di tiap user. Seorang user bisa mengakses objek mana saja.
--jo-- Oscar Wilyanto wrote: > > Jadi kalau saya mau buat sebuah schema untuk satu modul aplikasi, > misalnya 'personalia'.. nama usernya juga harus 'personalia'? > > dan setiap aplikasi yang ingin mengambil/menulis data di schema > 'personalia', aplikasi tidak bisa akses ke objek2 didalam schema > 'personalia' selain menggunakan username 'personalia'? > > bagaimana caranya jika kita ingin membuat satu schema bisa diakses > oleh beberapa username? misalnya dalam kasus ini usernamenya adalah: > manajer_hrd, spv_hrd, hrd01, hrd02... masing2 memiliki priviledges > berbeda2 terhadap tabel2 dan view2 di dalam schema 'personalia' tersebut. > > ----- Original Message ----- > From: Johannes Christian > To: [email protected] <mailto:indo-oracle%40yahoogroups.com> > Sent: Friday, February 16, 2007 12:56 PM > Subject: Re: [indo-oracle] Schema dan user > > AFAIK, satu user itu satu schema. > > Schema itu seperti environment dari user itu. hampir sama dengan user di > sistem operasi. Punya profile sendiri > > --jo-- > Oscar Wilyanto wrote: > > > > Dear Masters, > > > > Mo nanya neh.. sorry basic banget.. > > > > Apa beda schema dengan user? kok sepertinya di Oracle 10g disamain? > > > > Jadi satu user itu satu schema? > > > > Thanks in Advance, > > > > Oscar > > > > ---------------------------------------------------------- > > This message contains confidential information and is intended only > > for the > > individual named. If you are not the named addressee you should not > > disseminate, distribute or copy this e-mail. Please notify the sender > > immediately by e-mail if you have received this e-mail by mistake and > > delete > > this e-mail from your system. E-mail transmission cannot be guaranteed > > to be > > secure or error-free as information could be intercepted, corrupted, > lost, > > destroyed, arrive late or incomplete, or contain viruses. MKD Group > > therefore > > does not accept liability for any errors or omissions in the contents > > of this > > message, which arise as a result of e-mail transmission. If > > verification is > > required please request a hard-copy version. > > > > MKD Group, www.mkdgroup.com > > ---------------------------------------------------------- > > > > [Non-text portions of this message have been removed] > > > > > > ---------------------------------------------------------- > This message contains confidential information and is intended only > for the > individual named. If you are not the named addressee you should not > disseminate, distribute or copy this e-mail. Please notify the sender > immediately by e-mail if you have received this e-mail by mistake and > delete > this e-mail from your system. E-mail transmission cannot be guaranteed > to be > secure or error-free as information could be intercepted, corrupted, lost, > destroyed, arrive late or incomplete, or contain viruses. MKD Group > therefore > does not accept liability for any errors or omissions in the contents > of this > message, which arise as a result of e-mail transmission. If > verification is > required please request a hard-copy version. > > MKD Group, www.mkdgroup.com > ---------------------------------------------------------- > > [Non-text portions of this message have been removed] > > -- Regards, Johannes Sitorus PT Pacific Communication Networks Wisma Indovision lt.12 Jl. Raya Panjang Z/III 11520 Tel. 021-5830-2430 Fax. 021-5830-2431
