setting up a new database - remove any permissions?

  • From: Jeff Chirco <backseatdba@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 9 Aug 2016 16:42:27 -0700

Wondering if any of you have basic scripts you run everytime you create a
new database.  What do you configure? Do you remove any permissions from
PUBLIC?  I know I have experimented with removing certain objects from
PUBLIC but found that it came back to bite me when applying patches and
updates.  Patches would either fail or cause some components to not be
valid.

What do any of you do.

Thanks,
Jeff

Other related posts: