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?
Who is Participating?
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?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.