I would kindly ask for you help.
I have Toad for Oracle version 12.0.1, I have 2 databases, there I can do on both various tasks like compare object, session browser, but I have a problem that on one database I cannot start database monitor which gives the following error - you do not have access to the required views to use the database monitor in this connection.
According the documentation there some synonyms which are needed for the function to work:
you do not have access to the required views to use the database monitor in this connection
The following public synonyms must be present.
I could find all besides x$ksllt, but this is missing also on the database there I can start database monitor.
IM using the system user for the connection, but if I try I application user it works.
the grants for the system users are as follows:
– 5 Roles for SYSTEM
GRANT APPL_OWNER TO SYSTEM WITH ADMIN OPTION;
GRANT AQ_ADMINISTRATOR_ROLE TO SYSTEM WITH ADMIN OPTION;
GRANT DBA TO SYSTEM WITH ADMIN OPTION;
GRANT MGMT_USER TO SYSTEM;
GRANT PLME_RW TO SYSTEM WITH ADMIN OPTION;
ALTER USER SYSTEM DEFAULT ROLE ALL;
– 5 System Privileges for SYSTEM
GRANT CREATE MATERIALIZED VIEW TO SYSTEM;
GRANT CREATE TABLE TO SYSTEM;
GRANT GLOBAL QUERY REWRITE TO SYSTEM;
GRANT SELECT ANY TABLE TO SYSTEM;
GRANT UNLIMITED TABLESPACE TO SYSTEM WITH ADMIN OPTION;
Thank you in advance