Database Administration (MOSC)

MOSC Banner

Revoke access from table - oracle database 19c

Hi Team,

We want to revoke select access for READONLY user on table xxttd_flex_value_sets_tab. But we are unable to revoke. Not sure who and how they gave access on that table to READONLY user.

SQL> sho user
USER is "READONLY"

SQL>SELECT
'Basic ' || vl.description
FROM
xxbps.xxttd_flex_value_sets_tab vs,
xxbps.xxttd_flex_values_tab vl
WHERE
vs.valueset_id = vl.valueset_id
AND vs.valueset_name = 'XXBPS_RESTAPI_VS'
AND vs.status = 'Active'
AND vl.status = 'Active'
AND upper(vl.value) = 'BPS AUTH KEY';

'BASIC'||VL.DESCRIPTION

Basic RkFQUkRJTlQ6b00zIzEyMzQ1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center