It's a documented feature - only the owner of an object can grant
privileges to someone else. The DBA doesn't have this privilege (unless
the owner granted with admin option).
Danny wrote:
> 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:57:15 CST
