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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
