Ability to specify permission grants in model
Posted: Fri 24 Jun 2016 13:29
My application is for PostgreSQL database but I think this applies to all server types.
Can there be a way to grant access permissions to an entity as part of the model? I have created a database and deployed my schema, but each table is owned by the login role that I used in my connection string for the deployment. I would like to have an option to specify desired access rights to a group role, since the best practice would be to grant access rights to a group, not a login.
A similar question relates to specifying the owner of the table when deploying it. Can I control the table owner when deploying the schema from Entity Developer to the database?
Maybe if there was a way to execute some DDL script as part of the model deployment process it would help.
Can there be a way to grant access permissions to an entity as part of the model? I have created a database and deployed my schema, but each table is owned by the login role that I used in my connection string for the deployment. I would like to have an option to specify desired access rights to a group role, since the best practice would be to grant access rights to a group, not a login.
A similar question relates to specifying the owner of the table when deploying it. Can I control the table owner when deploying the schema from Entity Developer to the database?
Maybe if there was a way to execute some DDL script as part of the model deployment process it would help.