Coba di grant create any table regards yopz
--- On Wed, 7/2/08, dony widiotomo <[EMAIL PROTECTED]> wrote: From: dony widiotomo <[EMAIL PROTECTED]> Subject: [indo-oracle] need help..!! create table via script To: [email protected] Date: Wednesday, July 2, 2008, 6:45 PM Dear Oracle-ers.. . saya mau bikin table menggunakan procedure di dlm packages.. kurang lebih spt ini : create or replace package PKG_create_table is procedure sp_create_table; end PKG_create_table; / create or replace package body PKG_create_table is procedure sp_create_table as begin execute immediate 'create table tb_02 as select * from tb_01'; end; end PKG_create_table; tp saat di-execute muncul ora-01031 : insufficient privileges.. sedangkan saat script ini : begin execute immediate 'create table tb_02 as select * from tb_01'; end; saya execute secara manual, tabel bisa di-create dengan sukses.. knp ya..?? utk role privileges user db yg bersangkutan, sudah di grant utk 'dba' thanx before for your help... [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
