SQL SERVER equivalent DBA,CONNECT,RESOURCE roles in Oracle

Posted on 2005-04-27
Last Modified: 2008-02-01
Can you give me SQL Server equivalent of DBA,CONNECT,RESOURCE roles in Oracle? Can you state the simularity and difference between them?
    LVL 28

    Accepted 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.
    LVL 75

    Expert Comment

    by:Anthony Perkins
    LVL 75

    Expert Comment

    by:Anthony Perkins
    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?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now