Difference between revisions of "Main Page/msbdata postgis"

From phurvitz
Jump to: navigation, search
m (Protected "Main Page/msbdata postgis" [edit=sysop:move=sysop] [cascading])
 
(No difference)

Latest revision as of 16:52, 13 October 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