Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> privilege question
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
![]() |
![]() |