ORA-01446 When Granting Select Privilege On CS_COUNTER Objetcs (Doc ID 2549918.1)

Last updated on DECEMBER 19, 2022

Applies to:

Symptoms

When attempting to Grant Select on CS Counter objects,
the following error occurs.

ERROR
-----------------------
GRANT SELECT ON APPS.CS_COUNTERS_DFV TO APPS_READ_ROLE failed. -1446 - ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc..


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Database
2. Created a read role (ex: APPS_READ_ROLE) to grant SELECT on all tables/views owned by APPS schema.
3. Execute the below SQL,

GRANT SELECT ON APPS.CS_COUNTERS_DFV TO APPS_READ_ROLE;
GRANT SELECT ON APPS.CS_COUNTER_GROUPS_DFV TO APPS_READ_ROLE;
GRANT SELECT ON APPS.CS_COUNTER_PROPERTIES_DFV TO APPS_READ_ROLE;
GRANT SELECT ON APPS.CS_COUNTER_PROPERTIES_V TO APPS_READ_ROLE;

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.