Permissions Tutorial

Database Schema Designer allows you to tap into SQL Server's user rights system.   When creating Database objects it is essencial to give the users the proper rights to access those objects.   Here you will find described the methods to manage Permissions for your Database objects.

  1. Open Manage Permissions Screen:

    To open Application Permissions:
    • On the Application Settings screen click the Manage Permissions button to open the Applications Permissions screen.
      * See Application Settings Tutorial to learn how to open the Application Settings screen.
      Application Permissions

    To open Schema Permissions:
    • Click "Schema -> Manage -> Object Permissions"
      Schema Permissions
  2. Managing Permissions:
    There are 4 object types supported by Database Schema Designer for Permissions.   They are: Functions, Stored Procedures, Tables and Views.   Use the drop-down list "Object Types" to choose which object type is displayed in the list below it.
    Permissions are applied to the Object Types as a group.   If you require Permissions on the individual Object level you must define those Permissions in the After Script of the Schema.
    With the exception of selecting the Object Type, this screen works in the same way as a Manage screen.   Click here to learn how to use a Manage Screen.
    Object Type
  3. Add/Edit Permissions:
    You can GRANT SELECT, INSERT, UPDATE, DELETE or EXECUTE Permissions using this screen.
    The Database User in which you are granting Permissions to is supplied by you and must already exist in the Database.
    Edit Permissions
  4. Click the OK button to submit your new settings.
    - Or -
    Click the Cancel button to discard your changes.