newbie question

From: Danny <d.stolle_at_chello.nl>
Date: Wed, 27 Nov 2002 21:09:50 GMT
Message-ID: <ywaF9.487553$F9.18185015@Flipper>

Hi all,

i have created several users and one user holds the tables. i have created several synonyms. now i want to grand SELECT privileges on these synonym object to several users.
i am outside the schema of the user which holds the tables and the user i am logged on is the DBA.
now when i want to grand the privileges i get the error ORA-01031 insufficient privileges.

what more sufficient privileges do you need to grand object privileges on objects to users outside your own schema.

thanx,
Danny Received on Wed Nov 27 2002 - 15:09:50 CST