I want to grant permissions through sqlalchemy, but for some reason if I let an engine execute the sql it does not work:
Code: from sqlalchemy import * engine = create_engine('postgres://localhost/Test') engine.echo = True engine.execute('CREATE USER testuser;') engine.execute('GRANT SELECT ON TABLE testtable TO testuser;') Result: Test=# \z testtable Access privileges for database "Test" Schema | Name | Type | Access privileges --------+---------------+-------+-------------------- public | checkout_info | table | {koen=arwdxt/koen} (1 row) And when I do the exact same sql in psql Test=# CREATE USER testuser; CREATE ROLE Test=# GRANT SELECT ON TABLE testtable TO testuser; GRANT Test=# \z testtable Access privileges for database "Test" Schema | Name | Type | Access privileges --------+---------------+-------+------------------------------------ public | Test | table | {koen=arwdxt/koen,testuser=r/koen} (1 row) I never had any problems doing any other sql stuff like creating triggers etc with this. Anyone got a hint? Thanks, Koen --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---