• Article

Database User (General Page)

Use this page to view or modify properties for the database user. Database User is accessed in two ways: either by right-clicking Users in Object Explorer and then clicking New User, or by right-clicking an existing user and then clicking Properties. When you right-click an existing user and then click Properties, some of the options below are not editable.

To gain access to a database, a login must be identified as a database user. The database user is usually known by the same name as the login, but you can create a database user (for a login) with a different name. Authentication is performed for the login; therefore, attributes such as the domain identity (for a Windows login) or the password (for a SQL Server login) are configured on the Login Properties (General Page). Access this page from Object Explorer under the server Security tree, not from the database Security tree.

Options

  • User name
    Enter a user name for the selected login name. If you are editing an existing user, this option cannot be changed.

  • Login name
    Select a login name from the list if you are creating a new user. If you are editing an existing user, this option cannot be changed.

  • Certificate name
    Displays the certificate name if created with a certificate.

  • Key name
    Displays the key name if created with an asymmetric key.

  • Without login
    Indicates the login was created using the WITHOUT LOGIN clause.

  • Default schema
    Specifies the schema that will own objects created by this user, unless otherwise specified.

  • Schemas owned by this user/Owned Schemas
    Select or view schemas that are owned by this user. A schema can be owned by only one user.

  • Database role membership/Role Members
    Select the database role membership, if any, for the user from the list of all available database roles.

    Note

    All users are also included in the public role. Public membership is permanent and cannot be changed.