Обсуждение: Sequence and Schema permissions information schema
PostgreSQL v9.1.6 Are sequence and schema permissions documented anywhere in the information schema. I've looked through documentation and the information_schema itself but have had no luck. I noticed in the 9.2 documentation there is a reference to 'sequences' in information_schema.usage_privileges. I also noticed there is a has_schema_privilege and has_sequence_privilege function so I'm assuming this data is somewhere? Thanks Rob -- View this message in context: http://postgresql.1045698.n5.nabble.com/Sequence-and-Schema-permissions-information-schema-tp5726514.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
hartrc <rhart2@mt.gov> writes: > PostgreSQL v9.1.6 > Are sequence and schema permissions documented anywhere in the information > schema. In 9.1, I don't believe so. According to the GRANT reference page, which I think is accurate, privileges on schemas are a PG extension not found in the SQL standard; so of course the standard's views wouldn't have anyplace to expose that information. As for the sequence situation, you might find the commentary and documentation changes in this 9.2 commit of interest: http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=82e83f46a2ed311c6e7536f607f73a6f2a1d7dea regards, tom lane