Re: newbie question {02}

From: Danny <d.stolle_at_chello.nl>
Date: Wed, 27 Nov 2002 21:39:20 GMT
Message-ID: <cYaF9.488211$F9.18212220@Flipper>

Oh yes, before you come with the system privileges CREATE PUBLIC SYNONYM. the user has this privilege, so i tested it... only inside the schema from the user having the tables it is possible to create public synonyms. only outside, with the same privileges i get the error ORA-01031.

help.
Danny

"Danny" <d.stolle_at_chello.nl> wrote in message news:ywaF9.487553$F9.18185015_at_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:39:20 CST