Grant

From: ALTAIR, RSP_4 <RSP_4.ALTAIR_at_EU.RHODIA.COM>
Date: Tue, 8 Aug 2000 08:51:53 +0200
Message-Id: <10583.114036@fatcity.com>

Hi,

I'm having a little problem with grants :

I have 5 PL/SQL procedures (This procedures are used to reconstruct start values of sequences)

   1 - One That drops sequences
   2 - One That creates sequences under current user 's schema
   3 - One That drops public synonyms (for this sequences)
   4 - One That creates public synonyms
   5 - Grant privileges on public synonyms to ROLE1, ROLE2, ROLE3

In order, i call 1,2,3,4,5
When i use the schema owner (tables + sequences ) it works very well, but when i use another user it fails when coming to point 5 with ORA 1031

In that procedure i have statements like that :

EXECUTE IMMEDIATE 'GRANT SELECT, ALTER SYNSEQ1 TO ROLE1, ROLE2, ROLE3' But if i do the same with calling each statement from SQL PLUS (SQL Directly), i have no error.

Is there a problem with execute immediate ? Is there a right that is missing ?
How can i solve this problem ?

Thank you very much

Seb

PS : I'm using Oracle v8.1.6 Personal Received on Tue Aug 08 2000 - 01:51:53 CDT