Re: How to block access to a scheme

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Eduardo Sá dos Reis<eduardoreis@xxxxxxxxxxxxx> 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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux