Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> privilege question

privilege question

From: S.A. <adenwalaNO_SPAM_at_att.com>
Date: Mon, 29 Oct 2001 23:13:20 -0500
Message-ID: <9rjtt5$87i3@kcweb01.netnews.att.com>


I connect to my 8.1.7 instance as user "bugle" and create table named "bugle_table" in this schema.

Then I connect as sys and issue following:

GRANT SELECT ON BUGLE.BUGLE_TABLE TO <another_existing_user>;

I get
ORA-01031: insufficient privileges.
Why is sys not able to do this? I tried the same with an existing id having DBA role, and get the same error.

thanks Received on Mon Oct 29 2001 - 22:13:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US