-
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.
-
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
-
Forum Rules
|
|