oracle所有表权限,oracle把所有表查询权限赋与另一用户

第一种select 'grant select on user2.'||t.table_name||' to user1;' from dba_tables t where t.owner='JTSJK';

第二种

create or replace procedure grant_sql as

The_c1          Integer;

The_result      number;

v_Table     varchar2(80);

v_sql       varchar2(400);

Begin

The_C1 :=Dbms_sql.open_cursor;

Dbms_sql.parse(the_C1,'Select table_name From User_Tables',dbms_sql.native);

Dbms_sql.define_column(the_c1,1,v_Table,80);

The_result:=Dbms_sql.execute(The_c1);

loop

If dbms_sql.fetch_rows(The_c1) > 0 then

Dbms_sql.column_value(The_c1,1,v_Table);

v_sql := 'Grant Select On '||v_Table||' to brokeruser3';

Execute Immediate v_sql;

else

exit;

End if;

end loop;      Dbms_sql.close_cursor(The_C1);End;