Why are TOAD schema objects granted to PUBLIC ? (4315917)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

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 TOAD
IDENTIFIED BY <password>
DEFAULT TABLESPACE TOOLS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 15 System Privileges for TOAD
GRANT 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 TOAD
ALTER USER TOAD QUOTA UNLIMITED ON TOOLS;
Other users besides TOAD can see TOAD objects. Can we modify this to prevent public access?
Resolution

If you only want to access TOAD schema objects while logged in as TOAD, it is OK to remove the grants on TOAD's objects to the public.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title