Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Who is this called
Hallo,
I would have searched google if I would know how this statement is
called.
I searched the SQL reference but could not find it.
I use it but I don't know the term.
select 'GRANT SELECT ON '||view_name||' to USER_ROLE ;'
from ALL_VIEWS
where owner = 'MYSELF'
and view_name != 'SYSTEM'
order by view_name ;
best regards
ke
Received on Tue Jan 10 2006 - 06:39:24 CST
![]() |
![]() |