Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Views and Roles
Is there any way a user can create a view on tables residing in another schema without having to grant explicit select rights to the tables? I would like to use roles but Oracle will not let the user create the view based on those tables.
Thanks Rob Received on Tue Jun 26 2001 - 16:14:23 CDT