Ray
New Pleskian
Hello.
Our developers like to export the databases from time to time, and also need DBO Schema permission on thier databases as they are usually developed elsewhere (as DBO) and then imported.
This means the defaults as set up by Plesk are unsuitable and I need to manually change them every time after creating a database.
Is there a way to change the default permissions when creating a MSSQL database with Plesk so this extra step is not needed?
In Particular I'd like to grant [DBO] schema and DBO permissions, as well as db_datareader, db_datawriter role membership.
Our developers like to export the databases from time to time, and also need DBO Schema permission on thier databases as they are usually developed elsewhere (as DBO) and then imported.
This means the defaults as set up by Plesk are unsuitable and I need to manually change them every time after creating a database.
Is there a way to change the default permissions when creating a MSSQL database with Plesk so this extra step is not needed?
In Particular I'd like to grant [DBO] schema and DBO permissions, as well as db_datareader, db_datawriter role membership.