truncate partition privilige
hello,
i have a small problem with the truncate partition privilige.
let me describe the scenario:
user a - contains a partitioned table named TAB.
user b - has "drop any table" and has a procedure that can truncate partition (recieves a table name and partition name)
if i run the following command
alter table TAB truncate partition xxx_92009 update... - the command works fine.
if i run the procedure i recieve: insufficient privliges. important to add the procedure was created with user b.
if i add the authid current_user to the procedure, it works. but i dont want to add it, since the purpose of this procedure is for other non privilged users to truncate a partition.
let me describe the scenario:
user a - contains a partitioned table named TAB.
user b - has "drop any table" and has a procedure that can truncate partition (recieves a table name and partition name)
if i run the following command
alter table TAB truncate partition xxx_92009 update... - the command works fine.
if i run the procedure i recieve: insufficient privliges. important to add the procedure was created with user b.
if i add the authid current_user to the procedure, it works. but i dont want to add it, since the purpose of this procedure is for other non privilged users to truncate a partition.
0