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] 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]
