GRANT CREATE TABLE ke user anda. Privilege yang harus di grant secara langsung (tidak lewat role) ke user jika mau di gunakan dalam PLSQL procedure.
2008/7/3 dony widiotomo <[EMAIL PROTECTED]>: > 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] > > > -- Cheers, Yoel Susanto www.indo-oracletech.com [Non-text portions of this message have been removed]
