Hello @Swati_Bhat ,
As we're waiting for help from the rest of the Community, you can check out these documentation articles, which explains how to manage your MSSQL extensions and how to get even more information by creating your own MSSQL extension.
As this is in the extensions forum: Do you mean with the MSSQL extension (which currently doesn't capture stored procedures), or do you mean through the OneAgent deep monitoring? I'd expect the latter, but just want to make sure before moving the thread to the correct forum.
I did not find anything related to the permissions except the following WARN is appearing in the logs.
[c0ceabd8-545e-3465-a186-f0e9fae683bd][-8419178555432512324][out][c0ceabd8-545e-3465-a186-f0e9fae683bd]2023-06-08 | 13:20:08.413 | pool-2-thread-2 | WARN | c.d.s.p.p.GroupPoller | While polling from endpoint XXXXX-scan:0000:ABCD, querying group 'Redo', some metrics were ignored because Database returned null value: [com.dynatrace.extension.sql-oracle.memory.sga.redoBuffer.redoLogSpaceWaitTime, com.dynatrace.extension.sql-oracle.memory.sga.redoBuffer.redoSizeIncrease, com.dynatrace.extension.sql-oracle.memory.sga.redoBuffer.redoWriteTime, com.dynatrace.extension.sql-oracle.memory.physicalReads, com.dynatrace.extension.sql-oracle.memory.physicalReadsDirect, com.dynatrace.extension.sql-oracle.memory.memorySorts, com.dynatrace.extension.sql-oracle.memory.diskSorts]