Re: granting privileges on other user

From: Bob Beilstein <rjbeilstein_at_earthlink.net>
Date: 2000/03/03
Message-ID: <aYTv4.1657$VG6.68065@newsread1.prod.itd.earthlink.net>#1/1

Actually, it's "WITH GRANT OPTION". "WITH ADMIN OPTION" is only for granting roles.

/ Bob

"Igor V. Podolsky" <igoryok_at_soft-review.kiev.ua> wrote in message news:AAJ8aluy90T_at_soft-review.kiev.ua...
> "Doug Cowles" <dcowles_at_i84.net> wrote in message
> news:38beb947.697559_at_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_at_soft-review.kiev.ua)
>
Received on Fri Mar 03 2000 - 00:00:00 CST