Main Page/msbdata postgis
From phurvitz
< Main Page
Revision as of 16:52, 13 October 2009 by Phil Hurvitz (talk | contribs) (Protected "Main Page/msbdata postgis" [edit=sysop:move=sysop] [cascading])
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
