Re: Why can't SYS user grant privilege on others' tables?

do this:

SQL> grant select any table to system with admin option;

+--------------------------------------------------------------------------+

| Vitaliy Mogilevskiy
| Senior Consultant
| CORE Technology Group, Inc.
| E-mail:    vit100gain_at_earthlink.net
| Web Page:  http://home.earthlink.net/~vit100gain/index.html

|            *** Free DBA Script Library at my Web Page ***
+--------------------------------------------------------------------------+

pradyumn_sharma_at_hotmail.com wrote:

> * Using Personal Oracle7, release 7.2.2.3.1. I log on as
> sys/change_on_install, and give the following command:
>
> SQL> grant select on pradyumn.x to system;
> grant select on pradyumn.x to system
> *
> ERROR at line 1:
> ORA-01031: insufficient privileges
>
> Why so?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

-- Received on Fri Apr 09 1999 - 12:47:56 CDT