Monday, June 29, 2015

DB Table Grants


For each table under DB schema must be next granting clause, so in USER can access and modify data inside that table:

 

GRANT SELECT ON <TABLE_NAME> TO QUERY_ROLE;

 

GRANT DELETE, INSERT, SELECT, UPDATE ON < TABLE_NAME> TO UPDATE_ROLE;

 

No comments: