Re: Insufficient privileges for GRANT

From: krissco <kris.scorup_at_gmail.com>
Date: Mon, 10 Sep 2007 15:40:06 -0000
Message-ID: <1189438806.137921.193840@y42g2000hsy.googlegroups.com>

> By defaullt, SYS does not have any object privilege on
> schema objects and so it cant' grant them.
>
> Btw, don't use SYS for anything but maintenance purpose.
> Why don't you use A to grant privilege on A objects?
>
> Regards
> Michel

Thank you for your response.

It worked. . . The strange thing is that I tried that first (must have goofed something up though). I was totally confused when - logged in as owner of the table - I couldn't grant that permission. Like I said, must have goofed up something before.

What do you mean by this:
> By defaullt, SYS does not have any object privilege on
> schema objects and so it cant' grant them.

I was (apparently mistaken) that since SYS has the "GRANT ANY" privilege then that meant I could grant from any table.

Thank you again,

-Kris Received on Mon Sep 10 2007 - 10:40:06 CDT