Oracle Object Rights

Pls. Help me to grant object previlege to a user. I've logged in to oracle 8i, using an account, which has DBA rights. But it will give me an error "ORA-01031 Insufficient Previleges". System previlege can grant. what am I supposed to do?

To grant a system privileges, you must either have been granted the system privileges with the ADMIN OPTION or have been granted GRANT ANY PRIVILEGE system privilege.

You can grant object privileges users those are created by the same user (with DBA privileges). But you cannot grant the object privileges to other users those are created by different DBA user.
For example look at the following tree :

SCOTT
|
--------------------- USER1
|
--------------------- USER2
|
--------------------- USER3
ACCOUNTS
|
-------------------- ACC1
|
-------------------- ACC2

The SCOTT user can grant the object or system privileges to pnly user USER1,USER2,USER3 not to ACC1, anf ACC2 because these users are created by different user i,e ACCOUNT.

Regards

No, there is nothing wrong with your configuration. Oracle does not allow you to grant the objects privileges, hold by the other users. Only users who are the owner of that objects, suppose to grant the priviliges of thier objects to other users. For example:

If System/Manager user wants to grant select priviliges on emp table hold by the Scott/tiger, cause to generate the 'insufficient privileges' error message.

Hi shafique,

I've tried that way and it really works....Many thanks.. And I hope you will help me to solve this also.

In my database even SYS or SYSTEM can’t grant other user's object privileges. Is it the correct way or is it my configuration problem?

great...thanks for the reply.