• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 685
  • Last Modified:

SQL SERVER equivalent DBA,CONNECT,RESOURCE roles in Oracle

Can you give me SQL Server equivalent of DBA,CONNECT,RESOURCE roles in Oracle? Can you state the simularity and difference between them?
  • 2
1 Solution
Here are the available roles in SQL Server.  I am not familiar with the roles in Oracle but based on these definitions, I guess you will be able to select their equivalent:

Fixed Server Roles
sysadmin - Can perform any activity in SQL Server.
serveradmin - Can set serverwide configuration options, shut down the server.
setupadmin - Can manage linked servers and startup procedures.
securityadmin - Can manage logins and CREATE DATABASE permissions, also read error logs and change passwords.
processadmin - Can manage processes running in SQL Server.
dbcreator - Can create, alter, and drop databases.
diskadmin - Can manage disk files.
bulkadmin - Can execute BULK INSERT statements.

Fixed Database Roles
db_owner - Has all permissions in the database.
db_accessadmin - Can add or remove user IDs.
db_securityadmin - Can manage all permissions, object ownerships, roles and role memberships.
db_ddladmin - Can issue ALL DDL, but cannot issue GRANT, REVOKE, or DENY statements.
db_backupoperator - Can issue DBCC, CHECKPOINT, and BACKUP statements.
db_datareader - Can select all data from any user table in the database.
db_datawriter - Can modify any data in any user table in the database.
db_denydatareader - Cannot select any data from any user table in the database.
db_denydatawriter - Cannot modify any data in any user table in the database.
Anthony PerkinsCommented:
Anthony PerkinsCommented:
I realize you are new here, so I suggest you spend some time reading the EE Guidelines, specifically the section on EE Grading standards:
What's the right grade to give?

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now