From: "Bob Beilstein" Subject: Re: granting privileges on other user Date: 2000/03/03 Message-ID: #1/1 References: <38beb947.697559@news.remarq.com> X-Priority: 3 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 X-Complaints-To: abuse@earthlink.net X-Trace: newsread1.prod.itd.earthlink.net 952109958 168.191.60.45 (Fri, 03 Mar 2000 10:59:18 PST) Organization: Manugistics, Inc. X-MSMail-Priority: Normal Reply-To: "Bob Beilstein" NNTP-Posting-Date: Fri, 03 Mar 2000 10:59:18 PST Newsgroups: comp.databases.oracle.server Actually, it's "WITH GRANT OPTION". "WITH ADMIN OPTION" is only for granting roles. / Bob "Igor V. Podolsky" wrote in message news:AAJ8aluy90T@soft-review.kiev.ua... > "Doug Cowles" wrote in message > news:38beb947.697559@news.remarq.com... > > Isn't it possible to grant privileges on someone else's table to yet > > another user as sys, or anyone as sysdba for that matter? > > > > Was trying to (paraphrased) - connect internal > > svmgrl> grant select on INV.SOMETABLE to VANUSER; > > and got > > .....insufficient privileges..... > > > > Must you be logged in as the owner of the object in order to grant > > something? > > Sure. Only object owner can grant any object privereles to someone. But > object owner can grant privelege with admin option. > > -- > Is There A God Or Any Kind Of Justice Under The Sky... (Queen'91) > > Igor V. Podolsky (igoryok@soft-review.kiev.ua) >