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).