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

Hello Maxim

These documents dont seem to explain how I can grant additional privileges to a database user... Currently the database user that I use has 'CONNECT', 'RESOURCE' and 'DBA' roles granted to him. There are no other roles that I can assign.. However I think that it is possible to create custom defined roles... but I cant figure out how to do this from the documentation. How do I specify that the database user that I am using has privilege to view the DBMS_CRYPTO table?

Thanks
Swetha

Maxim Demenko wrote:
> 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 Sun Oct 08 2006 - 00:42:49 CDT