This article explains how to use the Server Permissions ribbon to manage server permissions on the selected server. Security management buttons are enabled only on the Database Engine’s Logins & Roles report.

Grant

Grant Server Permissions allows you to add logins to the fixed server roles on the selected database engine.

• Available On: Database Engine’s Logins & Roles report
• Scope: Currently selected database engine

Please note! If a login does not exist on the selected server, it will be created.

Revoke

Revoke Server Permissions allows you to revoke fixed server roles for the selected principal on the selected database engine.

• Available On: Database Engine’s Logins & Roles report
• Scope: Currently selected database engine

Drop

Drop Login deletes selected server logins from the selected database engine.

• Available On: Database Engine’s Logins & Roles report
• Scope: Currently selected database engine

Edit

Edit Server Permissions allows you to edit fixed server roles for the selected principal on the selected database engine.

• Available On: Database Engine’s Logins & Roles report
• Scope: currently selected database engine