Friday, September 10, 2010

Server Roles In SQL Server

Fixed server roles are Server level Securables.

Here is a list of Fixed Server Level Roles In SQL Server 2005

PROCESS ADMIN: Process Admin manages the processes, running in an Instance of SQL Server

SERVER ADMIN: Server Admin role is used to configure the server wide settings.

SECURITY ADMIN: Security Admin role is used to manage the server Logins

SETUP ADMIN: Setup Admin role is used to add or remove linked servers

DISK ADMIN: Disk Admin role is used to manage the disk files

BULK ADMIN: Bulk Admin role is used to execute bulk insert statements

SYS ADMIN: Sys Admin role is used to take full control of the server system

DB CREATOR: Database Creator role is used to create and alter databases

DB OWNER: By using DB Owner role we can have full control of the database

PUBLIC: By using public role, we can view and expand the databases
Understanding roles in SQL Server security. Understanding SQL Server fixed server roles. New User-defined Server Roles in SQL Server 2012. SQL Server roles. Create Your Own Fixed Server Roles In SQL Server. SQL Server Security: Server Roles. SQL Server Role Membership. sql server server role for backups. sql server server role public. sql server server role sysadmin. Removing a SQL Server Database Role. Setting up users and roles in SQL Server. SQL Server Agent Fixed Database Roles. CREATE ROLE . Transact-SQL. CREATE SERVER ROLE. ALTER SERVER ROLE. Security Role Requirements for Replication. Server-Level Roles. User Defined Server Role on SQL Server 2012. Add SQL 2012 custom Server role to allow and deny certain tasks. SQL Server User Defined Server Roles. SQL Server 2008 server role.

0 comments:

Post a Comment