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 ("Insufficie nt
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
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 ("Insufficie nt
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