REPOST: Re: Privilege on another sheme
Date: Sat, 29 Dec 2001 22:03:59 +0100
Message-ID: <0$--$$-$-%$-%_-$_$_at_news.noc.cabal.int>
On Fri, 28 Dec 2001 23:27:03 +0100, "Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote:
>"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!
As a rule you shouldn't crosspost and multipost at all. You're wasting bandwith and you won't get better responses, and I will waste time on your multiposted messages, if they have been already responded to. Also nobody died from typing and I'm well aware how often you are asking questions you could easily have found the answer yourself.
Regards
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address
- WAS CANCELLED BY =======: Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!colt.net!diablo.netcom.net.uk!netcom.net.uk!cpk-news-hub1.bbnplanet.com!news.gtei.net!nntp.abs.net!uunet!dca.uu.net!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r From: Sybrand Bakker <postbus_at_sybrandb.demon.nl> Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.tools Subject: cmsg cancel <smbs2u44cf1t1c3r8t703i126fek08prhc_at_4ax.com> Control: cancel <smbs2u44cf1t1c3r8t703i126fek08prhc_at_4ax.com> Date: Wed, 2 Jan 2002 01:30:45 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.smbs2u44cf1t1c3r8t703i126fek08prhc_at_4ax.com> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009948139 29203 166.102.15.34 (2 Jan 2002 05:08:59 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 2 Jan 2002 05:08:59 GMT X-No-Archive: yes Comment: Dude, where's my NewsAgent? Xref: news.uni-stuttgart.de control:40287079
autocancel Received on Sat Dec 29 2001 - 22:03:59 CET