privileges needed for execute immediate 'grant select...'? [message #179215] |
Mon, 26 June 2006 07:01  |
hellcat
Messages: 84 Registered: January 2006 Location: Zug, Switzerland
|
Member |
|
|
hi
I've got a proc. looking like this:
create or replace procedure grant_table(p_table in varchar2, p_privilege in varchar2, p_to_user in varchar2, p_grantoption in boolean)
authid current_user
is
begin
execute immediate 'grant ' || p_privilege || ' on ' || p_table || ' to ' || p_to_user || case when p_grantoption then ' with grant option' else '' end;
end grant_table;
unfortunately I get a runtime error (ORA-01031: insufficient privileges). what privilege do I need to grant directly to this account that it can successfully grant the privs. ?
thanks
|
|
|
|
|
|
|