• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Question MSSQL server default permissions.

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.
 

Attachments

  • permissions.jpg
    permissions.jpg
    98 KB · Views: 9
Back
Top