Can "ANY" Privileges be Removed from [prefix]_STB And [prefix]_IAU Database Users? (Doc ID 2243177.1)

Last updated on MARCH 17, 2017

Applies to:

Oracle WebCenter Sites - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Goal

Is it supported/possible to remove the "ANY" privileges from the [prefix]_STB and [prefix]_IAU users?

[prefix]_STB before: CREATE TABLE CREATE TYPE CREATE ANY TRIGGER CREATE ANY INDEX CREATE PROCEDURE CREATE SEQUENCE
[prefix]_STB after: CREATE TABLE CREATE TYPE CREATE PROCEDURE CREATE SEQUENCE

[prefix]_IAU before: CREATE TABLE UNLIMITED TABLESPACE CREATE TYPE CREATE SYNONYM CREATE SESSION SELECT ANY DICTIONARY CREATE INDEXTYPE CREATE PROCEDURE CREATE SEQUENCE
[prefix]_IAU after:  CREATE TABLE UNLIMITED TABLESPACE CREATE TYPE CREATE SYNONYM CREATE SESSION CREATE INDEXTYPE CREATE PROCEDURE CREATE SEQUENCE
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms