pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
How to block access to a scheme 2+ messages / 2 participants [nested] [flat]
* How to block access to a scheme @ 2010-04-08 13:59 Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br> 0 siblings, 1 reply; 2+ messages in thread From: Eduardo Sá dos Reis @ 2010-04-08 13:59 UTC (permalink / raw) To: pgsql-admin; +Cc: felipe_lt@yahoo.com.br How to block access to a scheme I have a database with multiple schemas. I need to block access to a particular scheme for doing maintenance on the structure of your tables. Does anyone know how to block access to the schema. I also need to disconnect users who are accessing the system. Grateful. Eduardo Reis ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to block access to a scheme @ 2010-04-08 14:53 Kevin Grittner <Kevin.Grittner@wicourts.gov> parent: Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br> 0 siblings, 0 replies; 2+ messages in thread From: Kevin Grittner @ 2010-04-08 14:53 UTC (permalink / raw) To: Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>; pgsql-admin; +Cc: felipe_lt@yahoo.com.br Eduardo Sá dos Reis<eduardoreis@pjf.mg.gov.br> wrote: > How to block access to a scheme > > I have a database with multiple schemas. I need to block access to > a particular scheme for doing maintenance on the structure of your > tables. Does anyone know how to block access to the schema. I'm not sure I exactly understand, but you can probably find something on this page that will help: http://www.postgresql.org/docs/8.4/interactive/sql-revoke.html Perhaps this?: REVOKE ALL ON SCHEMA x FROM y; > I also need to disconnect users who are accessing the system. http://www.postgresql.org/docs/8.4/interactive/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL-TABLE Before using these functions, you probably want to modify the pg_hba.conf file and signal a reload, to block new logins. -Kevin ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-04-08 14:53 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2010-04-08 13:59 How to block access to a scheme Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br> 2010-04-08 14:53 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
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