Difference between revisions of "Main Page/msbdata postgis"
From phurvitz
Phil Hurvitz (talk | contribs) (New page: 1078 % createuser Enter name of role to add: msbdata Shall the new role be a superuser? (y/n) y phurvitz@gist ~/msb/s01 1079 % psql msb -U msbdata Welcome to psql 8.3.7, the PostgreSQL in...) |
Phil Hurvitz (talk | contribs) |
||
| Line 1: | Line 1: | ||
| + | <pre> | ||
1078 % createuser | 1078 % createuser | ||
Enter name of role to add: msbdata | Enter name of role to add: msbdata | ||
| Line 12: | Line 13: | ||
msb=# grant all on schema msbdata to sde; | msb=# grant all on schema msbdata to sde; | ||
msb=# GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE public.geometry_columns TO msbdata | msb=# GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE public.geometry_columns TO msbdata | ||
| + | </pre> | ||
Revision as of 22:06, 19 April 2009
1078 % createuser Enter name of role to add: msbdata Shall the new role be a superuser? (y/n) y phurvitz@gist ~/msb/s01 1079 % psql msb -U msbdata Welcome to psql 8.3.7, the PostgreSQL interactive terminal. msb=# grant all on database msb to msbdata; msb=# alter user msbdata with password 'msbdata'; msb=# create schema authorization msbdata; msb=# grant all on schema msbdata to sde; msb=# GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE public.geometry_columns TO msbdata
