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

Last updated on JUNE 24, 2024

Applies to:

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

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