pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Where are security permissions stored ? 2+ messages / 2 participants [nested] [flat]
* Where are security permissions stored ? @ 2011-06-08 10:36 Thorne, Francis <ft55@leicester.ac.uk> 0 siblings, 1 reply; 2+ messages in thread From: Thorne, Francis @ 2011-06-08 10:36 UTC (permalink / raw) To: pgsql-admin In postgres 8.3.6 could you please tell me where the security permission details for users are stored (i.e. who has select on a particular table), for example in the master database in M-SQL, am I right in thinking these details are stored in pg_catalog and if so I'm guessing this should be backed up Thanks FT ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Where are security permissions stored ? @ 2011-06-08 18:46 Guillaume Lelarge <guillaume@lelarge.info> parent: Thorne, Francis <ft55@leicester.ac.uk> 0 siblings, 0 replies; 2+ messages in thread From: Guillaume Lelarge @ 2011-06-08 18:46 UTC (permalink / raw) To: Thorne, Francis <ft55@leicester.ac.uk>; +Cc: pgsql-admin On Wed, 2011-06-08 at 11:36 +0100, Thorne, Francis wrote: > In postgres 8.3.6 could you please tell me where the security > permission details for users are stored (i.e. who has select on a > particular table) Column relacl in the pg_class table of the pg_catalog schema. > , for example in the master database in M-SQL, am I right in thinking > these details are stored in pg_catalog and if so I’m guessing this > should be backed up > pg_dump takes care of this for all the objects you dump. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-06-08 18:46 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2011-06-08 10:36 Where are security permissions stored ? Thorne, Francis <ft55@leicester.ac.uk> 2011-06-08 18:46 ` Guillaume Lelarge <guillaume@lelarge.info>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox