Unanswered: is it possible for different schema to share the same sequence?
lets say i have 2 schemas, schema a and schema b.
i've created 2 sequences and 2 triggers for each schema.
currently, both schema a and schema b is sharing the same sequence which is from schema b. Is that possible? If yes, how to fix that, i want each schemas to use its own sequences and triggers and not from another schema.
I'm a little bit confused ... in the first post you said that there are sequences in both schemas, but you use only one sequence - the one which is created in schema B.
You don't want that - you want that programs written in schema A use sequence from schema A, and programs in schema B to use sequence from schema B.
In your second post, you said that there are NO grants on those sequences at all. If that's true, how can red coloured text be correct? User A can NOT use sequence from schema B if there's no "GRANT SELECT ON sequence_from_schema_B TO user_A" (or PUBLIC).
Maybe other people see it clear, but I don't; could you explain it again, please? What you have and what you'd like to have?
P.S. If you'd like to remove possibility that schema A uses sequence from schema B, simply "REVOKE ALL ON sequence_from_schema_B FROM user_A".