grants gives - Search results in mailing lists
Mailing lists >> pgsql-novice >> Thread >> Search in thread (2)
2023-09-12 02:04:41 | Re: Grant CREATE privilege on all schemas (Tom Lane)
ivanov17@riseup.net writes: This is not supported, and it's not likely to ever become supported
Mailing lists >> pgsql-novice >> Thread
2019-07-29 00:26:52 | Re: How do I upgrade psql from version 7 to be 10 in Windows 10 (Karen Goh)
give me error. That password is not recognised. It is the same password I use for that username in psql. So, by right, I should gain access right? I mean I have stated
Mailing lists >> pgsql-novice >> Thread
2017-11-27 20:15:08 | Re: Novice question about users and...rights? (Stephen Frost)
GRANT'd to the users who should have a given role (or roles). This also means you can essentially avoid having the application have to care about authentication or authorization, since it's all done
Mailing lists >> pgsql-novice >> Thread
2014-06-16 17:45:33 | Simple commands don't work (Larry Martell)
give myself a password. I read in the online docs the command was this: phis=> alter user larry set password = 'XXXX'; ERROR: unrecognized configuration parameter "password" Then I read somewhere else it is: phis=> ALTER
Mailing lists >> pgsql-novice >> Thread >> Search in thread (2)
2013-08-16 15:01:48 | Re: sudo/access to the postres OS user (Birchall, Austen)
granting rights on files at an individual level? Your SAs are [I can't say in polite company]. Have them create a dba group and put all the DBAs in it. Then setup postgres
Mailing lists >> pgsql-novice >> Thread
2013-04-11 23:02:18 | Re: about view privileges (Kevin Grittner)
give permission to create views to users who can't be trusted not to grant
Mailing lists >> pgsql-novice >> Thread >> Search in thread (2)
2013-03-13 12:44:41 | [postgresql 9.2.3] schema and privileges (kobolds)
give privileges to connect to the db1, 8. using postgres, grant connect on database db1 to user1
Mailing lists >> pgsql-novice >> Thread >> Search in thread (2)
2013-02-12 11:54:38 | Re: GRANT USAGE ON DATABASE xxx TO public fails (Thomas Kellerer)
grant connect on database agency to public; But you also need to give public access
Mailing lists >> pgsql-novice >> Thread
2012-10-23 15:28:11 | Grant / Revoke on Views and prepared statements (Alex Cornford)
giving minimum privileges to task defined roles. I want to block user level access to the tables. I am trying to only allow access via views and prepared statement for user roles. Is it possible
Mailing lists >> pgsql-novice >> Thread >> Search in thread (2)
2012-06-04 08:39:39 | Re: database in different location owned by different user (Luca Ferrari)
give them the appropriate permissions (grants) to work on a database, a table, and so on. On Mon, Jun 4, 2012 at 12:51 PM, Van Orden
Mailing lists >> pgsql-novice >> Thread
2012-05-31 03:26:59 | permissions (Ross Boylan)
gives each OS user passwordless login to their own databases if you setup a pg user with the same name. Edited pg_hba.conf to trust all users for the database of interest, rossmail. Owner
Mailing lists >> pgsql-novice >> Thread
2010-11-16 14:00:18 | ALTER DEFAULT PRIVs / not working for me (Michael Rau)
give R/W access to user2 of a table which has been created by user1. The complete SQL flow is: | ---------------------------------------------------------------------- $ sudo -u postgres psql psql (9.0.1) Type "help" for help. postgres=# create database test; CREATE DATABASE
Mailing lists >> pgsql-novice >> Thread
2010-04-28 12:59:35 | how to continue after error in batch mode with psql (Urs Rau)
give us error messages about all lines with errors? So I want: ERROR: value too long for type character varying(20) CONTEXT: COPY t_test, line 2, column t_comment_c: "'comment 3 that
Mailing lists >> pgsql-novice >> Thread
2009-09-25 00:06:59 | Re: what comes after apt-get for a Debian installation? (Tim Bowden)
Give your normal user account relevant postgresql permissions. as root (su - ) #su - postgres #createuser Answer questions as appropriate (ie, do you want superuser privileges? At the least, you'll probably want create database and probably
Mailing lists >> pgsql-novice >> Thread
2008-06-17 20:35:58 | pg_restore warnings (G. J. Walsh)
give me a detailed look at the process. The command was simply: pg_restore -v --disable-triggers -d thedb -Fc thedb.pgr At the start: WARNING no privileges could be revoked for "public" WARNING