Administration > Database Management > Access permissions > Database access permissions > Overview of database access permissions
Overview of database access permissions
At the database level you can set:
Database access permissions through Model Explorer
Database access permissions through Stored Procedures in SQL Server Management Studio
* 
Database Administrators and users that have Owner access permissions to a database have owner access rights to all Models and Packages in that database. These access permissions cannot be revoked at the Model or Model item level.
Database access permissions set through Model Explorer
Only Database Administrators can set Database access permissions in Model Explorer. You can set up the read, write and owner access permissions for a database:
Read Access Permissions
This access permission does not allow a user to do anything; however, if you grant a user Read access to a Database and then create, clone (using default access permissions) or import a Model in that database, the new Model will inherit the Read access permissions that are set for the database.
Write Access Permissions
Allows a user to:
Create Models in the database.
Import Models to the database.
Add profiles to models in the database.
* 
Having Write access permissions to a database does not grant any Write access permissions to the Models and Model items in that database.
The first person that uses a Reverser to reverse engineer code to a Model must have Write access permissions to the database, because the Reverser adds its associated profile to the Model.
Public Read
All users of the database have read access permissions to each Model in the database. This read access cannot be revoked at the Model or Model item level.
Owner Access Permissions
In addition to the access granted through Write access permissions, Owner access permissions gives a user Owner access permissions to all Models and Packages in the database.
Was this helpful?