RA-01952: system privileges not granted to 'user

[zircon06]

How to fix this error ! I'm using REVOKE SELECT ANY TABLE FROM USER and getting

ORA-01952: system privileges not granted to 'user

Thanks in advance

 

[Turkbear]

Hi,
Is 'USER' and actual user name??( I hope not)

the error says what the problem is:

ORA-01952 system privileges not granted to 'string'

Cause: A system privilege you tried to revoke was not granted to the user.

Action: Make sure the privileges you are trying to revoke are granted.

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[DrD123]

Hi zircon06,

You can see what privileges USER has before you revoke them, or verify he has what you're attempting to revoke.

select * from sys.DBA_TAB_PRIVS where OWNER='SCHEMA_NAME';

Good luck
DrD