REPOST: Re: Privilege on another sheme

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message 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!

Please, do not break my crossposts!

--

Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>

========= WAS CANCELLED BY =======:
Path: news.sol.net!spool1-nwblwi.newsops.execpc.com!newsfeeds.sol.net!priapus.visi.com!news-out.visi.com!hermes.visi.com!newsfeed.direct.ca!look.ca!newsfeed1.earthlink.net!newsfeed.earthlink.net!uunet!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r
From: "Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR>
Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.tools
Subject: cmsg cancel <a0l3sd$4nsa$1_at_as201.hinet.hr>
Control: cancel <a0l3sd$4nsa$1_at_as201.hinet.hr>
Date: Wed, 2 Jan 2002 02:18:27 GMT
Organization: Navix Internet Subscribers
Lines: 2
Message-ID: <cancel.a0l3sd$4nsa$1_at_as201.hinet.hr>
NNTP-Posting-Host: 166.102.15.34
X-Trace: iac5.navix.net 1009948160 29203 166.102.15.34 (2 Jan 2002 05:09:20 GMT)
X-Complaints-To: abuse_at_navix.net
NNTP-Posting-Date: 2 Jan 2002 05:09:20 GMT
X-No-Archive: yes
Comment: Dude, where's my NewsAgent?

autocancel