On Nov 1, 7:45 pm, Jignesh Makwana <makwanajigne...@gmail.com> wrote: > You write nonsense and you also agree with the nonsense to some level. >
You can prove that statement? > By default,you can not use dynamic views in pl sql you need explicit > privilege on them. > > Regards, > Jignesh Makwana > On Nov 1, 2011 8:58 PM, "ddf" <orat...@msn.com> wrote: > > > > > Where are the explicit privileges on USER_TABLES in this series of grants: SQL> grant connect, create table, plustrace to bong; Grant succeeded. SQL> grant alter any procedure to bong; Grant succeeded. SQL> grant create any procedure to bong; Grant succeeded. SQL> grant create procedure to bong; Grant succeeded. SQL> grant debug any procedure to bong; Grant succeeded. SQL> grant drop any procedure to bong; Grant succeeded. SQL> grant execute any procedure to bong; Grant succeeded. SQL> grant create synonym to bong; Grant succeeded. SQL> grant create view to bong; Grant succeeded. SQL> grant create any type to bong; Grant succeeded. SQL> grant create any sequence to bong; Grant succeeded. SQL> grant drop any sequence to bong; Grant succeeded. SQL> The example still runs without error, and no explicit privileges on USER_TABLES have been granted: SQL> SQL> connect bong/###### Connected. SQL> SQL> set echo on SQL> SQL> create table yappo( 2 smort number, 3 albeister varchar2(20), 4 colname date 5 ); Table created. SQL> SQL> create table blue_yappo( 2 smort number, 3 albeister varchar2(20), 4 colname date 5 ); Table created. SQL> SQL> create table red_yappo( 2 smort number, 3 albeister varchar2(20), 4 colname date 5 ); Table created. SQL> SQL> describe yappo Name Null? Type ----------------------------------------- -------- ---------------------------- SMORT NUMBER ALBEISTER VARCHAR2(20) COLNAME DATE SQL> describe blue_yappo Name Null? Type ----------------------------------------- -------- ---------------------------- SMORT NUMBER ALBEISTER VARCHAR2(20) COLNAME DATE SQL> describe red_yappo Name Null? Type ----------------------------------------- -------- ---------------------------- SMORT NUMBER ALBEISTER VARCHAR2(20) COLNAME DATE SQL> SQL> declare 2 sqltxt varchar2(2000); 3 begin 4 for rec in (select table_name from user_tables where table_name like '%YAPPO') loop 5 sqltxt := 'alter table '||rec.table_name||' rename column colname to yertz'; 6 execute immediate sqltxt; 7 end loop; 8 9 end; 10 / PL/SQL procedure successfully completed. SQL> SQL> describe yappo Name Null? Type ----------------------------------------- -------- ---------------------------- SMORT NUMBER ALBEISTER VARCHAR2(20) YERTZ DATE SQL> describe blue_yappo Name Null? Type ----------------------------------------- -------- ---------------------------- SMORT NUMBER ALBEISTER VARCHAR2(20) YERTZ DATE SQL> describe red_yappo Name Null? Type ----------------------------------------- -------- ---------------------------- SMORT NUMBER ALBEISTER VARCHAR2(20) YERTZ DATE SQL> SQL> create table yuppo( 2 smort number, 3 albeister varchar2(20), 4 colname date 5 ); Table created. SQL> SQL> create table blue_yuppo( 2 smort number, 3 albeister varchar2(20), 4 colname date 5 ); Table created. SQL> SQL> create table red_yuppo( 2 smort number, 3 albeister varchar2(20), 4 colname date 5 ); Table created. SQL> SQL> describe yuppo Name Null? Type ----------------------------------------- -------- ---------------------------- SMORT NUMBER ALBEISTER VARCHAR2(20) COLNAME DATE SQL> describe blue_yuppo Name Null? Type ----------------------------------------- -------- ---------------------------- SMORT NUMBER ALBEISTER VARCHAR2(20) COLNAME DATE SQL> describe red_yuppo Name Null? Type ----------------------------------------- -------- ---------------------------- SMORT NUMBER ALBEISTER VARCHAR2(20) COLNAME DATE SQL> SQL> declare 2 sqltxt varchar2(2000); 3 begin 4 for rec in (select table_name from user_tables where table_name like '%YUPPO') loop 5 sqltxt := 'alter table yuppo rename column colname to yertz'; 6 execute immediate sqltxt; 7 end loop; 8 9 end; 10 / declare * ERROR at line 1: ORA-00957: duplicate column name ORA-06512: at line 6 SQL> SQL> describe yuppo Name Null? Type ----------------------------------------- -------- ---------------------------- SMORT NUMBER ALBEISTER VARCHAR2(20) YERTZ DATE SQL> describe blue_yuppo Name Null? Type ----------------------------------------- -------- ---------------------------- SMORT NUMBER ALBEISTER VARCHAR2(20) COLNAME DATE SQL> describe red_yuppo Name Null? Type ----------------------------------------- -------- ---------------------------- SMORT NUMBER ALBEISTER VARCHAR2(20) COLNAME DATE SQL> David Fitzjarrell -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
