Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to grant select on newly-created view...

user11921433Jan 27 2014 — edited Mar 27 2014

Hi,

I am not sure what is missing here. I get ORA-01031: insufficient privileges when trying to grant select on a view I just created to a new user. SO I tested again and again to see what could be wrong. Not sure. Please help. I haven't been able to wrap my head around this one. I create views and usually can grant select on those views without issue. Please help! THanks in advance.

Thank you,

SaY

T:\>sqlplus user1/useruser@oratest

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 24 08:54:49 2014

Connected to:

Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

SQL> CREATE OR REPLACE VIEW gname_view AS

2 SELECT * from all_homes

3 ;

View created.

SQL> grant select on gname_view to user2;

grant select on gname_view to user2

ERROR at line 1:

ORA-01031: insufficient privileges

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 24 2014

Added on Jan 27 2014

#general-database-discussions, #select

16 comments

1,034 views