Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Taking 'ages' to grant select privilege on table

Dan Scott GuestJan 4 2012 — edited Jan 5 2012

Hi,

I'm granting permissions for a user to be able to select from around 50 tables:

GRANT SELECT ON SCHEMA1.TABLE1 TO DANSCOTT;
GRANT SELECT ON SCHEMA1.TABLE2 TO DANSCOTT;
GRANT SELECT ON SCHEMA1.TABLE2 TO DANSCOTT;

The first 25 or so complete quickly and successfully. The script seems to have got stuck on one of the grants (Been running for over 10 minutes so far). I don't think there's anything special about the particular table and I can't think why granting permissions should take very long.

Can anyone tell me how to figure out why it's taking so long and what I need to do to fix it?

Thanks,

Dan Scott

This post has been answered by 907884 on Jan 4 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 2 2012

Added on Jan 4 2012

#general-database-discussions

4 comments

2,082 views