Return
-
Title
Why are TOAD schema objects granted to PUBLIC ? -
Description
Here is the script for the TOAD user that is created when Space History is configured:CREATE USER TOADIDENTIFIED BY <password>DEFAULT TABLESPACE TOOLSTEMPORARY TABLESPACE TEMPPROFILE DEFAULTACCOUNT UNLOCK;-- 15 System Privileges for TOADGRANT ALTER SESSION TO TOAD;GRANT CREATE ANY TRIGGER TO TOAD;GRANT CREATE PROCEDURE TO TOAD;GRANT CREATE PUBLIC SYNONYM TO TOAD;GRANT CREATE ROLE TO TOAD;GRANT CREATE SEQUENCE TO TOAD;GRANT CREATE SESSION TO TOAD;GRANT CREATE SYNONYM TO TOAD;GRANT CREATE TABLE TO TOAD;GRANT CREATE TRIGGER TO TOAD;GRANT CREATE TYPE TO TOAD;GRANT CREATE VIEW TO TOAD;GRANT DROP PUBLIC SYNONYM TO TOAD;GRANT SELECT ANY DICTIONARY TO TOAD;GRANT UNLIMITED TABLESPACE TO TOAD;-- 1 Tablespace Quota for TOADALTER USER TOAD QUOTA UNLIMITED ON TOOLS;Other users besides TOAD can see TOAD objects. Can we modify this to prevent public access?
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.