|
⇤ ← Revision 1 as of 2007-10-25 13:26:14
Size: 473
Comment:
|
Size: 941
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 2: | Line 2: |
| * Run psql as yourself, | * Run psql as yourself, (e.g. at prompt, type: psql -h hmidb -d jsoc), then type the following once you've entered psql (Postgres): |
| Line 5: | Line 5: |
| where seriesname is your series (e.g. su_name.myseries), and username is the user you want to access your series. Make sure to follow with the semi-colon to signal to Postgres that you want it to execute your command. If you hit return without it, type \g (for "go") or \r (for "reset" or "clear"). | |
| Line 15: | Line 16: |
(Semi-colons are not needed to execute \dp commands.) |
How to enable another user to ingest data into a series you've created
* Run psql as yourself, (e.g. at prompt, type: psql -h hmidb -d jsoc), then type the following once you've entered psql (Postgres):
- grant insert on seriesname to username;
- grant update on seriesname_seq to username;
where seriesname is your series (e.g. su_name.myseries), and username is the user you want to access your series. Make sure to follow with the semi-colon to signal to Postgres that you want it to execute your command. If you hit return without it, type \g (for "go") or \r (for "reset" or "clear").
* To grant permission to all users to insert records in the series (for example), type
- grant insert on seriesname to public;
- grant update on seriesname_seq to public;
To view the permissions of the data series:
- \dp seriesname
- \dp seriesname_seq
(Semi-colons are not needed to execute \dp commands.)