|
Re: Grant - Table & Trigger. [message #323332 is a reply to message #323326] |
Wed, 28 May 2008 04:17   |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
I'm guessing you haven't tried.
Had you tried before posting you'd have noticed that what you want to di isn't actually possible:SQL> create table trig_test (col_1 varchar2(10));
Table created.
SQL>
SQL> create or replace trigger trig_test_trg before insert on trig_test for each row
2 begin
3 null;
4 end;
5 /
Trigger created.
SQL>
SQL> grant execute on trig_test_trg to public;
grant execute on trig_test_trg to public
*
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist
|
|
|
|
|
|
Re: Grant - Table & Trigger. [message #323396 is a reply to message #323377] |
Wed, 28 May 2008 06:50   |
panyam
Messages: 146 Registered: May 2008
|
Senior Member |
|
|
Hi Micale,
Although after giving 'ALL' grant Permission For the table RAVI_TEST1 from itr_app Schema to Accountancy schema,i am not able to see the trigger on RAVI_TEST1 in Accountancy.
Here is wat i have done
create or replace trigger RAVI_TRIG before insert on ravi_test1
for each row
begin
DBMS_OUTPUT.PUT_LINE('hiiiiiii');
end;
In Accountancy schema
Insert into itr_app.ravi_test1 values ('GGGG',123,'K','');
I am able to Do Insert operation,..
My Question is when i give DESC RAVI_TEST1 in ACCOUNTANCY schema it will display as there are no triggers on it.
|
|
|
|
|
Re: Grant - Table & Trigger. [message #323413 is a reply to message #323396] |
Wed, 28 May 2008 07:54  |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
panyam wrote on Wed, 28 May 2008 07:50 |
create or replace trigger RAVI_TRIG before insert on ravi_test1
for each row
begin
DBMS_OUTPUT.PUT_LINE('hiiiiiii');
end;
|
I hope this was just a "sample" JRowbottom's test, because this trigger will do nothing. You will not see any output.
[added]Just to be clear, I meant that any insert via an application will not see any output. You will only see output in a SQL*Plus session.
[Updated on: Wed, 28 May 2008 07:57] Report message to a moderator
|
|
|