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...) |
(No difference)
|
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
