-
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
