alter role - superuser - permissions

From: Mike <1100100(at)gmail(dot)com>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: alter role - superuser - permissions
Date: 2016-09-04 14:25:13
Message-ID: CAECVvTU2JTd-qy3=T0LYq8Uf=cv5pMXGgekr4A09AsC2m0B4sQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I want to learn how to insert data into tables.
Using postgres 9.5.x on Fedora 24.

linux user account: mmm
postgres database: mmm
database mmm table: accounts

mmm=# \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------+-----------
mmm | Superuser, Create DB | {}
postgres | Superuser, Create role, Create DB, Replication | {}

Tried to use the copy command to insert data from .csv file into table
named "accounts"

It appears I was successful in altering the role of user "mmm" and
making it a superuser.

But, when I try the copy command, the following error occurs:

mmm=# copy accounts
(employ_last,employ_first,service,website,userid,password) from
'/home/mmm/Documents/accounts-services.csv';
ERROR: could not open file
"/home/mmm/Documents/accounts-services.csv" for reading: Permission
denied
mmm=#

If mmm is a superuser, and user mmm owns the mmm database, the .csv
file is in mmm's home directory, what other permissions are required
or still incomplete?

Thank you for your help.

Best regards,

Mike

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2016-09-04 14:52:15 Re: alter role - superuser - permissions
Previous Message Gary Evans 2016-09-01 22:48:31 Re: TImestamp with milliseconds or ten thousandths of a second