Re: Trigger to insert random number into Oracle 10g table

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Thu, 05 Oct 2006 13:13:55 +0200
Message-ID: <4524e929$0$32416$9b4e6d93@newsspool1.arcor-online.net>

swethasivaram_at_gmail.com schrieb:

>> What is the result of this query for you (meant for user in those schema
>> you try to create the trigger) ?
>>
>> SELECT * FROM user_tab_privs WHERE table_name = 'DBMS_CRYPTO';

>
> This query gives me 'no data found' when I execute it from the user in
> whose schema I try to create the trigger.
>

That means, you probably should look up at http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_4465.htm#sthref3359 and
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14220/security.htm#i13854

Best regards

Maxim Received on Thu Oct 05 2006 - 06:13:55 CDT