alter role - superuser - permissions

Поиск
Список
Период
Сортировка
От Mike
Тема alter role - superuser - permissions
Дата
Msg-id CAECVvTU2JTd-qy3=T0LYq8Uf=cv5pMXGgekr4A09AsC2m0B4sQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: alter role - superuser - permissions  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Re: alter role - superuser - permissions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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


В списке pgsql-novice по дате отправления:

Предыдущее
От: Gary Evans
Дата:
Сообщение: Re: TImestamp with milliseconds or ten thousandths of a second
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: alter role - superuser - permissions