Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Who is this called

Who is this called

From: <Kurt-Erich.Finger_at_hte-company.de>
Date: 10 Jan 2006 04:39:24 -0800
Message-ID: <1136896764.772288.82300@g47g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US