Forum Stats

  • 3,839,358 Users
  • 2,262,486 Discussions
  • 7,900,950 Comments

Discussions

Revoke select on "SYS"."SYSNTknJrmJu5AUzgUwoIEDDgnQ=="

User_ZNNFA
User_ZNNFA Member Posts: 1 Red Ribbon
edited Feb 19, 2020 9:49AM in Database Security - General

I need to revoke the select permission in the following tables from user "USRTDLLO":

"SYS"."SYSNTknJrmJu5AUzgUwoIEDDgnQ=="

"SYS"."SYSNTknJrmJu7AUzgUwoIEDDgnQ=="

"SYS"."SYSNTknJrmJu5AUzgUwoIEDDgnQ=="

but its dependencies are:

STANDARD (PACKAGE)

KUPC$_FILEINFO (TYPE)

KU$_LOGLINE1010 (TYPE)

when I try to revoke the privilege I get the following error:

revoke select on "SYS"."SYSNTknJrmJu5AUzgUwoIEDDgnQ==" from "USRTDLLO" ;

ora-22812 cannot reference nested table column's storage table

This is due to the fact that the audit area needs to eliminate these privileges, since they were granted by migration process with exp / imp and the permissions were assigned with script.