Privilege problem with creation

Hi there,

I'm writing an application which tests a database for objects using the data dictionary, and creates them if required. Up to now everything I've done has been tested using system/manager. However, I'm now trying to grant select on a certain table to a certain role. The user, table and role were all created by system/manager fine, but when I try to grant the privilege I get an ORA-01031 ("Insufficient privileges"). This is because the user which I'm using for all the operations does not have object privileges on table which it created. The user which owns it is locked, so I can't log on as that and do it (and would like ot do it in a more generic fashion). The question is, is there a way to ensure that a user which creates another user, then creates an item on that user, can grant itself object privileges on the created object? I'd like all of this to be done with one user is possible. Is there another way around this?

Ta,
Steve Received on Tue Apr 13 2004 - 18:03:13 CEST