Re: Privilege on another sheme
From: Kirti Deshpande <kirti_deshpande_at_hotmail.com>
Date: 28 Dec 2001 12:45:39 -0800
Message-ID: <e34bb569.0112281245.b99550c_at_posting.google.com>
Date: 28 Dec 2001 12:45:39 -0800
Message-ID: <e34bb569.0112281245.b99550c_at_posting.google.com>
"andrija" <ar35644_at_fer.hr> wrote in message news:<a0i4t0$1f6e$1_at_as201.hinet.hr>...
> > Grant dba provalges.
>
> Stupid. Don't do that.
There is no 'easy' way to do what you want. You will have to build a
script to do it.
Following is an example. Modify it as needed..
Run this while connected as user 'A'.
set pages 0
set feedback off
spool grants_to_B.sql
select 'GRANT ALL ON '|| object_name || ' TO B;'
from user_objects;
spool off
This would create the 'grants_to_B.sql' script. Run it while connected as user A.
That's about it...
Good Luck,
- Kirtikumar Deshpande