i have created a view which contains tables from two schemas.
there was no problem while creating the view but after creation while i am trying to give GRANT SELECT ON VIEW, i am getting an error which says "grant option does not exist for schema.table_name".