Hi All,
I am running below query, and I am getting all most all the privileges like select, update, insert, delete, drop, etc (255 Entries). I would like to remove all the privileges except select. How can I do that?
`SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE = 'UserX' ORDER BY PRIVILEGE;`
For Reference,
When I execute below query, I got only two GRANTED_ROLE => CONNECT and RESOURCE.
`SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTEE= 'UserX';`
When I execute below query, I got no entries.
`SELECT * FROM ROLE_ROLE_PRIVS WHERE ROLE IN ('CONNECT', 'RESOURCE');`
When I execute below query, I got entries with SELECT privilege only,
`SELECT * FROM DBA_TAB_PRIVS WHERE GRANTEE = 'UserX';`