By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,654 Members | 1,816 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,654 IT Pros & Developers. It's quick & easy.

Privilege problem with creation

P: n/a
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
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.