Oracle Database Discussions

Hi,

Need to grant a select privilege on a view in another schema to a new user
The user was created with

create user newuser identified by password default tablespace users temporary tablespace temp;

no quota mentioned as i did not want the user to create any objects.

then connect role was allocated to that user

grant connect to newuser;

after that i logged into the user where the view already exists.

grant select on viewname to newuser.

It gave me an error

ORA -01720 grant option does not exist for the table XXXX.

This table is internally present in the select statement that composed the view.

I also gave

grant select on XXX to the newuser but still it throws the same error.

database 10.2.0.3
env:windows 2003

Thanks