My Oracle Support Banner

Keep Sequence Grant Is Not Reflected In DBA_TAB_PRIVS (Doc ID 2939232.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.10.0.0.0 and later
Information in this document applies to any platform.

Goal

When I run the command "GRANT KEEP SEQUENCE ON SEQUENCE_NAME TO USER2;"

How can I verify that a database user2 has 'KEEP SEQUENCE' permission on that particular sequence?

It does not appear in any of the following views DBA_TAB_PRIVS, DBA_ROLE_PRIVS or DBA_SYS_PRIVS
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
References


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