Avoid analyze table to user
Hello.
Today a developer user (CONSO) has execute an ANALYZE TABLE statement on a table that belongs to its own schema, I mean:
ANALYZE TABLE CONSO.HISTOMOV ESTIMATE STATISTICS SAMPLE 33 PERCENT
These are the privileges for the user.
| PRIVILEGE |
----------------------------------------
| CREATE SESSION | |
| UNLIMITED TABLESPACE | |
| CREATE TABLE | |
| CREATE CLUSTER | |
| CREATE SEQUENCE | |
| CREATE PROCEDURE | |
| CREATE TRIGGER | |
| CREATE TYPE | |
| CREATE OPERATOR | |
| CREATE INDEXTYPE |
Two questions:
- How an user with no ANALYZE privileges can execute this statement? I guess because It's his own schema, but couldn't execute it in any other.
- How can I avoid any user (except SYS and SYSTEM) execute ANALYZE TABLE even in his own schema?
0