You can also grant permissions for an object directly in its property sheet.
-
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.
-
Click the Add Objects tool to open a selection box listing all the users (or roles or groups) in the model.
-
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.

-
[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:

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