Re: newbie question

On Wed, 27 Nov 2002 21:09:50 GMT, "Danny" <d.stolle_at_chello.nl> wrote:

>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
>

You can't do that unless the owner granted you privileges with admin option.
That is usually not recommended as you will end up with a myriad of grants.
In short, you need to be connect as the object's owner, or create the following procedure under the owner.

create or replace procedure <other_user>.do_ddl(sqlstr in varchar2) as begin
execute immediate sqlstr;
end;
/

now
begin <other_user>.do_ddl('grant ....'); end;

will do the trick.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Nov 27 2002 - 16:06:39 CST