[Babase] Making tables for other people
Susan Alberts
alberts at duke.edu
Fri Feb 23 09:08:13 EST 2007
Here is an additional comment on Leah's email. Last night she
created a table for me in sandbox, and instructed me to copy it into
my schema by creating a table of the same name and structure in my
schema and then using sql to:
INSERT INTO alberts.rankmemb
SELECT * FROM sandbox.rankmemb
The error message I got said "permission denied for relation
rankmemb". In other words, I can't access rankmemb in the sandbox
schema.
Susan
>Karl,
>
>What do you suggest as the best method for the data managers to make
>tables for other people (ie. eventually in their schema)? I am not
>sure of the best way to handle this. Should we create the table in
>the sandbox and have them insert the data into an identical blank
>table in their own schema? Any suggestions would be appreciated.
>Will we run into problems with table ownership in the sandbox?
>
>Thanks,
>Leah
>
>_______________________________________________
>Babase mailing list
>Babase at www.eco.princeton.edu
>http://www.eco.princeton.edu/mailman/listinfo/babase
--
--------------------------------------------------------------------------------------------------------------------------------------
Susan Alberts, Department of Biology, Duke University, Box 90338,
Durham NC 27708
919-660-7272 (phone), 919-660-7293 (FAX)
More information about the Babase
mailing list