A database User is a database-level security principal enabling object access permission control at the finest level of granularity. A user represents a single SQL Server login within the scope of the database in which the user is defined.
User Editor allows you to define user properties and membership. It opens automatically when you create a new user and is available on editing an existing one.
To open a user in User Editor, double-click it in the DB Explorer tree.
- Using Navigation bar and Toolbar
- Creating/editing user
- Defining user membership
- Editing object description
- Viewing DDL definition
- Setting object permissions