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

Hello Maxim

>> login as user SYS and issue "grant execute on DBMS_CRYPTO to your_user;".
My trigger works well now, after I did the above.

Thanks
Swetha

Maxim Demenko wrote:
> swethasivaram_at_gmail.com schrieb:
> > 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
> >
>
> Privileges can be granted to one particular user either directly or
> through a role. Roles were introduced to make privileges management
> easier, however sometimes privileges granted directly are still needed.
> This is the particular case of such situation - object referenced in a
> trigger should be granted directly. To call the DBMS_CRYPTO package(this
> is not a table) you have to grant rights to execute it directly to your
> user. To grant an object privilege in turn for non own object it is
> sufficient to have DBA role since 9i, however it doesn't rely to objects
> owner by user SYS ( and DBMS_CRYPTO is such object). Also, you have to
> login as user SYS and issue "grant execute on DBMS_CRYPTO to your_user;".
> I would encourage you as well to read more Oracle documentation, it is
> explained much better there than my attempt to do it.
>
>
> Best regards
>
> Maxim
Received on Sun Oct 08 2006 - 06:32:59 CDT