SQL> create user test identified by test default tablespace users;     

User created.

SQL> grant create session,analyze any to test;

Grant succeeded.

SQL> connect test/test
Connected.
SQL> execute dbms_stats.gather_table_stats('SCOTT','EMP');

PL/SQL procedure successfully completed.