Re: granting privileges on other user

"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)