How can one see if somebody modified any code.
Also, If scott has created the Procedure p1 which inserts the data into table t1 which is created in scott schema.if the scott gives the execute permission on produre p1 to denis(another user),denis also created the table t1 in his shema.when the denis execute the p1 in which user table will populate the data.
Data will always insert into scott schema.
Because by default all the procedures are Definer Right .
Define the procedure like this sample to make that invoker right. That means the user who is calling / invoking the procedure has all the right not the definer (the user who has defined the procedure and granted the priviliges.)
Code:create or replace procedure deptins ( dno dept.deptno%type, dn dept.dname%type, lc dept.loc%type ) authid current_user is begin insert into dept values(dno,dn,lc); dbms_output.put_line('one row inserted......!'); commit; exception when dup_val_on_index then dbms_output.put_line('duplicate value......!'); end;
Last edited by debasisdas; 01-10-2008 at 08:43 AM. Reason: formatting
Posting Permissions
Reply With Quote