Granting Permissions for an Object from Its Property Sheet

You can also grant permissions for an object directly in its property sheet.

  1. Open the property sheet of the object and click the Permissions tab. The columns in the list show the permissions available for the object in the current DBMS. Sub-tabs allow you to grant permissions to Users, Roles, and Groups.
  2. Click the Add Objects tool to open a selection box listing all the users (or roles or groups) in the model.
  3. Select one or more users and click OK to add them to the list of users with permissions on the object. If the user belongs to a group with permissions on the object, these permissions appear in red in the list.

  4. [optional] To change the state of a permission, click in the appropriate column until the desired state is displayed, or select one of the Permission state tools at the bottom of the tab:

  5. [optional] For tables, you can specify permissions on individual columns (see Defining column permissions).
  6. Click OK.