Control updates StabiBase Database with SQL Studio management

Problem:
A Stabibase administrator wants to prevent anyone from updating the shared database to a new version without authorization. Unintended updates occur when the database becomes locked—a requirement for any upgrade.

Solution:

1. In Studio Management, navigate to the server-level security settings and grant the user or group the Public role.

2. Under database-level security for the shared database, assign the DB_Writer and DB_Reader roles to the same user or group.
3. Ensure the user’s or group’s default database is set to your Stabicad database.

4. Set the default schema for that user or group to dbo.
5. Grant EXECUTE permissions on the database so the user or group can run the stored procedures needed by Stabicad.

6. To verify, start Stabicad and try creating a new project or drawing. If the database is not locked and you can create a project, your permissions are correctly set.

If you have any questions about this article, please contact the helpdesk directly