DBMS_REDEFINITION error...

Hi,

I am getting error while redefining simple table...
User has execute privilege on DBMS_REDEFINITION package, but
still I get privilege error..

CONNECT SCOTT/tiger@ORCL

CREATE TABLE jobs(
Id NUMBER NOT NULL PRIMARY KEY,
description VARCHAR2(100));

INSERT INTO jobs VALUES (1,'Teacher');
INSERT INTO jobs VALUES (2,'Supervisor');

CREATE TABLE jobstemp(jobid NUMBER NOT NULL PRIMARY KEY,
description VARCHAR2(200));

EXEC DBMS_REDEFINITION.CAN_REDEF_TABLE('SCOTT','JOBS');
EXEC DBMS_REDEFINITION.START_REDEF_TABLE('SCOTT','JOBS',-
'JOBSTEMP',-
'ID JOBID,-
DESCRIPTION DESCRIPTION');

Table created.

1 row created.

1 row created.

Table created.

PL/SQL procedure successfully completed.


BEGIN DBMS_REDEFINITION.START_REDEF_TABLE('SCOTT','JOBS', 'JOBSTEMP', 'ID JOBID,DESCRIPTION DESCRIPTION'); END;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_REDEFINITION", line 8
ORA-06512: at "SYS.DBMS_REDEFINITION", line 146
ORA-06512: at line 1


Please help!!!

Thanks

Sameer

execute privs through role? if so do

grant execute on DBMS_REDEFINITION to scott

Yes... priviledge is already granted directly... and not through role...

Got the answer....

USER also needs

ALTER ANY TABLE,
CREATE ANY TABLE,
DROP ANY TABLE,
LOCK ANY TABLE,
SELECT ANY TABLE

these privileges....


Sameer