Re: Privilege on another sheme

[Quoted] On Fri, 28 Dec 2001 09:33:37 +0100, "Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote:

>I've got user "A" having i.e. 100 objects in his scheme. What is the
>easiest way to grant user "B" full privilege on all object from scheme
>belonging to user "A"? I'd like user "B" to have completely all
>privileges on objects from user "A" scheme. I know user "B" cannot be
>owner but all other privileges; select, delete, alter, update...

Please RTFM, sql reference manual, the GRANT command, object privileges.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Dec 28 2001 - 10:08:48 CET