PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Expand]Guide for PANTHEON
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Collapse]User Manual for PANTHEON
   [Collapse]Getting Started
     Dictionary of terms
     First steps with PANTHEON
    [Expand]Using PANTHEON at Tecta, a fictional company
    [Expand]Instructions for Ensuring Compliance of PANTHEON with SAS
    [Expand]PANTHEON Installation
    [Collapse]PANTHEON System
     [Expand]PANTHEON System data
     [Collapse]MS SQL Server
       Download and install MS SQL Server
       Upgrading MS SQL Server to 2019 or 2022
       MS Management Studio - Download and install
       Restoring database onto SQL server
       Adding users to server level (AddUser_PAX)
       Installing SQL for external access
       Installing PANTHEON clients
       Nastavitve MS SQL strežnika za večja Pantheon™ oko
       Changing SQL Sort Order
      [Collapse]MS SQL Server Security
        Creating Server Logins
        SQL Server Service Settings
        Fixed Server Role
        Fixed Database Role
        Windows Authentication
        SQL Server Authentication
        Encrypting SQL Server Connections
      [Expand]Useful SQL Queries
       SQLExecute
      [Expand]SQL Server Jobs
     [Expand]Microsoft Windows Utilities
     [Expand]Security Policy
     [Expand]Database Administration
    [Expand]PANTHEON Basics
    [Expand]PANTHEON Help
    [Expand]Materials and Goods Movements
    [Expand]Assigning Identifiers
    [Expand]Frequently asked questions about Pantheon (F.A.Q.)
    [Expand]Archive
   [Expand]User Manual for eBusiness
   [Expand]Settings
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]Service
   [Expand]Help
   [Expand]Personnel
   [Expand]Financials
   [Expand]Analytics
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 406.2414 ms
"
   2012 | 2562 | 336922 | Updated
Label

Fixed Server Role

Fixed Server Role

Fixed Server Role

Server roles apply server-wide and the roles themselves cannot be changed, only applied to logins. The following server roles exist:

 

Server Role Permission
sysadmin Can perform any activity.
serveradmin Can configure the server-wide settings.
setupadmin Can manage extended stored procedures.
securityadmin Can manage the logins for the server.
processadmin Can manage the processes running in SQL Server.
dbcreator Can create and alter databases.
diskadmin Can manage the disk files.

Assigning Server Roles in Enterprise Manager

  1. In Enterprise Manager, find the desired SQL Server instance.
  2. Go to Security and then Server Roles.
  3. In the right-hand panel, right-click the desired role and select Properties.

In the General tab, click the Add... button  and select the logins that you wish to assign the selected role. The Permissions tab lists the actions that the selected role can perform.

004027.gif

Assigning Server Roles with T-SQL

You can assign server roles by running the following command:

sp_addsrvrolemember [@loginame =] 'login', [@rolename =] 'role'

You can remove server roles with the following command:

sp_dropsrvrolemember [@loginame =] 'login', [@rolename =] 'role'

where login is the login name you wish to add/remove, and role is the role you are assigning/removing.


 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!