Re: Privilege on another sheme
Date: Fri, 28 Dec 2001 23:27:03 +0100
Message-ID: <a0l3sd$4nsa$1_at_as201.hinet.hr>
[Quoted] [Quoted] "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
[Quoted] news:njdo2u4obmvttcfqq4hubrf4711tl2i5nu_at_4ax.com...
> 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.
Dear Sybrand, I know how to manually grant privileges to one particular object but, as I mentioned in IP, there is a lot of objects in scheme and I really do not want to do this manually for every object!
[Quoted] Please, do not break my crossposts!
-- Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>Received on Fri Dec 28 2001 - 23:27:03 CET