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
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 |