Skip to Main Content

SQL & PL/SQL

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!

Grant analyze on one table to another user

Arunadeepti JakkaFeb 10 2020 — edited Feb 10 2020

Hi all ,

Can anyone help me with the below query

I have a table in a schema user1.employee1

And I need to execute anlayze table employee1  gather statistics from user2.

I have executed below from

grant analyze on user1.employee1  to user2 

But this is not working .

Is there any other way ?

Thanks

Comments
Post Details
Added on Feb 10 2020
7 comments
12,344 views