Quote Originally Posted by PAVB View Post
Gathering stats on a non-owned schema requires 'analyze any" system privilege and also either 'select any' OR select on specific tables.

Yes, but here i am not granted any of these privileges to the user test and test1, but still they are able to gather the stats of the schema "WMEXT".
why it is happening ?

thanks
Gopu