DBMS_REDEFINITION error...

[Sameer]

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

[pando]

execute privs through role? if so do

grant execute on DBMS_REDEFINITION to scott

[Sameer]

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

[Sameer]

Got the answer....

USER also needs

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

these privileges....


Sameer