Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Posts
    28

    Unanswered: need to get grants on sequence

    Hey All -

    Please forgive me if this is a basic question, but a quick google & book search hasn't turned up an answer. Can someone please provide the sql to get the grants for a particular sequence? IE: I need something that will reverse engineer:

    GRANT SELECT ON GL.GL_SEQUENCE TO FOO_ROLE
    GRANT SELECT ON GL.GL_SEQUENCE TO JSMITH

    I'm coming from a mssql/sybase background where I can use "sp_helprotect GL.GL_SEQUENCE" (if that matters).

    Thanks in advance!

    Amy

  2. #2
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    select grantee, privilege from dba_tab_privs where table_name = 'GL_SEQUENCE' and owner = 'GL'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •