Re: Insufficient privileges for GRANT

"krissco" <kris.scorup_at_gmail.com> a écrit dans le message de news: 1189438806.137921.193840_at_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
|

You have GRANT ANY ROLE and GRANT ANY SYSTEM PRIVILEGE but not GRANT ANY OBJECT PRIVILEGE.
This latter privilege was introduced in 9i.

Regards
Michel Cadot Received on Mon Sep 10 2007 - 11:04:44 CDT