Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Revoke select on "SYS"."SYSNTknJrmJu5AUzgUwoIEDDgnQ=="

User_ZNNFA
Member Posts: 1 Red Ribbon
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.