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

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 - 05:21:28 CDT