Results 1 to 2 of 2

Thread: oracle predefined roles vs ms sql roles

  1. #1
    Join Date
    May 2005
    Posts
    3

    oracle predefined roles vs ms sql roles

    Hi! Can anyone say which ms sql server predefined roles are similar to the following oracle predefined roles: dba, connect, resource. I already know that sysadmin in MS SQL Server is the same as DBA in Oracle but what about the rest?
    Thanks a lot.

  2. #2
    Join Date
    Apr 2005
    Location
    florida
    Posts
    89
    Basically, if connect & resource are granted to a user, this user can do the followings only in the database in which this user can act:

    connect(ORACLE):
    create session, alter session, create synonym, create view, create database link, create table, create cluster and create sequence

    resource(ORACLE):
    create table, create cluster, create sequence, create trigger, create procedure, create type, create indextype and create operator

    This is pretty much the same for a SQL SERVER user having the db_owner: (little bit more)

    db_owner(SQL SERVER):
    Managing database access,Changing database options,Backing up and restoring the database contents,
    Granting and revoking database permissions,Creating and dropping database objects

    So, I would say: db_owner could be used in SQL SERVER as an equivalent of connect & resource in ORACLE.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •