My Oracle Support Banner

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

Last updated on MARCH 21, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.