Users Editor (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Editors

The Users Editor lets you manage properties, assign roles, and manage object bindings for a user.

To edit a user

  1. Open an editor on the user. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Properties

Lets you view the Without Login, Login Name, Name, User Type, Certificate, Asymmetric Key, and Default Schema properties.

Roles

Lets you assign roles to a user by selecting the check boxes associated with the roles to be assigned.

Objects

Lets you manage database objects (Defaults, Indexes, Procedures, Rules, Tables, Triggers, User Datatypes, Views) associated with the user. Objects are organized in a tree structure with folders containing the objects. Optionally, take one of the following actions:

Select an object and click Edit to open an object editor on the selected object. For information on each editor, use the links in Microsoft SQL Server Object Editors.

Select an object and click Drop to initiate dropping the selected object.

Object Permissions and System Permissions

For details on using these tabs, see Working with Privileges and Permissions.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.