MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » September 2012

Re: Set authority on SQL CREATE TABLE



fixed

I didn't realize I could do this. I think that'll work. Thanks!
--
Mike Wills
http://mikewills.me


On Wed, Sep 26, 2012 at 9:26 AM, Tom E Stieger <testieger@xxxxxxxxxxxx> wrote:
Try running the GRANT SQL command after the create statement.

Create table mylib.mytable as (balh, blah, blah);

Grant all on mylib.mytable to user;


-Tom Stieger
IT Manager
California Fine Wire





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact